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
Subscribe to:
Post Comments (Atom)
16 comments:
In psql for windows, is there a way to use VIew as a pager in side of psql? Are there any other pagers like less for windows that have a similar behavior that can be used?
iirc (it's been a while since i worked on windows), win should follow the same rules...so, you can set environment variables (in the system control panel) for the same effect. windows doesn't ship with less, only more, so you will have to find that as well...try the gnu page, cygwin, or mingw.
I would also suggest adding to the LESS environment the "-e" switch. I have long found it annoying to have to explicitly quit the pager, so this will allow quitting by pressing a key a second time when at the end of the output.
May I just add an , 'A-men' to the -e (minus eeee) suggestion to this post. That is _much_ more intuitive to use under man pages or whatever. Thank you, I'm adding that nugget to my standard post-install notebook.
NickBurnsSNL ;)
Exactly what I was looking for, thanks for pointing it out!
People should read this.
thanks guys, that really makes the difference :)
Thanks .. perfect .. it is life saver
thank you for yuor tip
Sweet
Gorgeous!
psql-specific LESS options can be set in .psqlrc using \setenv, so if your preferred options in PostgreSQL conflict with your normal LESS options, you can put them there.
Steve, you just made my day
Note that if you put the less flags in your .psqlrc the syntax is slightly different:
\timing
\pset pager always
\setenv LESS '-iMSx4 -FX'
anon,
\setenv trick is defintely the way to go. thanks for the heads up!
I used this LESS configuration and it messed up my `git log --oneline --decorate --graph` output. But if you add an 'R' flag, colors will also work.
I.E.
export LESS="-iMSx4 -FXR"
Post a Comment