scrolling in psql..

How do i make psql to scroll thru the entire result set rather than
using the PAGER which makes it stop after each page..

\pset pager

template1=# \pset pager
Using pager is off.
template1=# \pset pager
Using pager is on.

Sincerely, Warren

How do i make psql to scroll thru the entire result set rather than
using the PAGER which makes it stop after each page..

While this doesn't directly answer your question, if your intent is just
to get to the last of the result set, "G" will do the trick for you, or "q"
will get you back to the psql command line.

steve

Anand Raman writes:

How do i make psql to scroll thru the entire result set rather than
using the PAGER which makes it stop after each page..

\pset pager

Put this into your ~/.psqlrc.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/