Обсуждение: key in psql

Поиск
Список
Период
Сортировка

key in psql

От
"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?


Re: key in psql

От
"Richard Huxton"
Дата:
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


Re: key in psql

От
Jose Manuel Lorenzo Lopez
Дата:

"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                    **
**********************************************************************