martin.chantler@convergys.com writes:
> For example in DB2 you can execute SQL from the command line (via terminal
> emulator)
> It will perform it entirely then display the results, but only one page at
> a time
> You can then page down and page up within the results (or scroll across)
>
> I notice that PSQL doesn't do this which makes large tables difficult to
> maintain
As another poster correctly guessed, you need to set the PAGER environment
variable to 'less'. The default pager is 'more', which is less
sophisticated, but it is the standard, more or less. (Pun not intended,
but tolerated.)
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/