Thread: select command doesnot work

HI

I installed Postgresql 8.3.3 in windows XP, try to input some commands in windows command prompt. The create, update and insert command  work all right, just select command.got the error message:  "more" is not internal or external command, not runnable program or bat file. Why did I input like "mydb => select * from .....;" but PG suppose what I enter is "more"?

thanks for help

am  Tue, dem 08.07.2008, um 21:46:53 +1000 mailte Long Cui folgendes:
> HI
>
> I installed Postgresql 8.3.3 in windows XP, try to input some commands in
> windows command prompt. The create, update and insert command  work all right,
> just select command.got the error message:  "more" is not internal or external
> command, not runnable program or bat file. Why did I input like "mydb => select
> * from .....;" but PG suppose what I enter is "more"?
>
> thanks for help

Please show us a complete command and the message from pg.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

On Tuesday 8. July 2008, Long Cui wrote:
>HI
>
>I installed Postgresql 8.3.3 in windows XP, try to input some commands
> in windows command prompt. The create, update and insert command
> work all right, just select command.got the error message:  "more" is
> not internal or external command, not runnable program or bat file.
> Why did I input like "mydb => select * from .....;" but PG suppose
> what I enter is "more"?
>
>thanks for help

Obviously, the XP version of psql uses the command "more" for paging the
output when it's too big to show in a single page. As I'm using Linux
myself, I can't give you any specific advice, but it appears that the
command "more" for some reason is not found in the path of your system.
That's a little strange, as "more" has been part of the MS toolbox
since the Stone Age of DOS.

--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
My Jazz Jukebox: http://www.last.fm/user/leifbk/

--On Dienstag, Juli 08, 2008 21:46:53 +1000 Long Cui
<choilon2000@gmail.com> wrote:

> I installed Postgresql 8.3.3 in windows XP, try to input some commands in
> windows command prompt. The create, update and insert command  work all
> right, just select command.got the error message:  "more" is not internal
> or external command, not runnable program or bat file. Why did I input
> like "mydb => select * from .....;" but PG suppose what I enter is "more"?

psql uses more to paginate results of your SELECT command. Seems like
'more' is missing in your setup.

--
  Thanks

                    Bernd

On 08/07/2008 13:17, Bernd Helmle wrote:
> psql uses more to paginate results of your SELECT command. Seems like

Is this the case on both Windows and Linux? - that psql uses more for
paging, as opposed to doing it itself?

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On Tuesday 8. July 2008, Raymond O'Donnell wrote:
>On 08/07/2008 13:17, Bernd Helmle wrote:
>> psql uses more to paginate results of your SELECT command. Seems
>> like
>
>Is this the case on both Windows and Linux? - that psql uses more for
>paging, as opposed to doing it itself?

It uses "less" on Linux.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
My Jazz Jukebox: http://www.last.fm/user/leifbk/

--On Dienstag, Juli 08, 2008 15:12:44 +0200 "Leif B. Kristensen"
<leif@solumslekt.org> wrote:

>> Is this the case on both Windows and Linux? - that psql uses more for
>> paging, as opposed to doing it itself?
>
> It uses "less" on Linux.

Seems to me that less is the default on cygwin, only. For others the
default is more, unless you override this via PAGER.

--
  Thanks

                    Bernd