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
try it!! now wide query results will paginate much better and searching is much easier.
update: fixed quotes for LESS, thanks depesz
The writings of Merlin Moncure, professional database developer, about work, life, family, and everything else.
Friday, October 19, 2007
Subscribe to:
Posts (Atom)