select command doesnot work

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