key in psql

Started by bcs-brockmann.deabout 25 years ago3 messagesgeneral
Jump to latest
#1bcs-brockmann.de
r.brockmann@bcs-brockmann.de

Sorry for my stupid question, but I am a new user!

Which key should I use after qsql has displayed the result of a select
statement.
On the sceen i see my result and <END>.
What key for continue which a new command?

#2Richard Huxton
dev@archonet.com
In reply to: bcs-brockmann.de (#1)
Re: key in psql

From: "bcs-brockmann.de" <r.brockmann@bcs-brockmann.de>

Sorry for my stupid question, but I am a new user!

Which key should I use after qsql has displayed the result of a select
statement.
On the sceen i see my result and <END>.
What key for continue which a new command?

Not a stupid question - I can't reproduce that here. If the select shows
more than one screen of results I get "More" and pressing the spacebar shows
the next page. At the end of the results you should get the command prompt
again (database name plus =>)

If you're still having trouble could you cut and paste an example of what
you have on-screen for us?

- Richard Huxton

#3Jose Manuel Lorenzo Lopez
jose-manuel.lorenzo-lopez@conti.de
In reply to: Richard Huxton (#2)
Re: key in psql

"bcs-brockmann.de" schrieb:

Sorry for my stupid question, but I am a new user!

Which key should I use after qsql has displayed the result of a select
statement.
On the sceen i see my result and <END>.
What key for continue which a new command?

Hello,

after psql displayed the result use <spacebar> to scroll the list. If
you
want to leave the list use the command ':q'. If you don't want this
scrolling feature execute comand '\pset pager'. Use the same command
to turn scrolling on.

Best Regads / Un saludo / Mit freundlichen Gr��en / Cordiali Saluti

Jos� Manuel Lorenzo L�pez

--
**********************************************************************
** Jos� Manuel Lorenzo L�pez **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** e-mail to: jose-manuel.lorenzo-lopez@conti.de **
**********************************************************************