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à
Subscribe to:
Post Comments (Atom)
-
I've been using WinScp and a script to compress files at maximum compressión, name the file as name_YYMMDD-HHMM.rar, and send them to a...
-
tomado de: http://el-directorio.org/ErroresComunesPhpmyadmin ARREGLAR ERROR 1045 (28000): Access denied for user 'root'@'localho...
-
Styling Excel cells with mso-number-format mso-number-format:"0" NO Decimals mso-number-format:&quo...
update:
ReplyDeletei find it a lot more useful not using the S option... S = chop long lines, i like then folded...
whener you press right arrow key, the lines are show non-folded
another useful option with less is the -#, which controls the amount of characters to the left or right that less shifts when the arrow is pressed...
ReplyDeletethis can be also set dinamically, by pressing ESC 10 RIGHTARROW (moves 10 characters to the right)