output console psql postgresql / editor

this post i read really makes psql better: http://merlinmoncure.blogspot.com/2007/10/better-psql-with-less.html


you could also try PAGER="more", i used to like it better

A better psql with less
psql is a great tool, but not very good at browsing data. Or is it? The following settings will make psql much more usable.

in your user profile:
export PAGER=less
export LESS="-iMSx4 -FX"

in your .psqlrc (make it if it's not already there)

\timing
\pset pager always

log in into psql ...

voilà