Thread: scrolling in psql..

scrolling in psql..

From
Anand Raman
Date:
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

Re: scrolling in psql..

From
"Steve Wolfe"
Date:
> 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



Re: scrolling in psql..

From
Warren Vanichuk
Date:
> 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


Re: scrolling in psql..

From
Peter Eisentraut
Date:
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/