Thread: scrolling in psql..

hi guys

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

Thanks
Anand

> 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

> 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

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/