Pgcli outputs query results in a pager (e.g.
allows you to easily view large result sets one page at a time.
Configuring the Pager
When starting up, pgcli checks the
pager config option in the config
file. If it's set, then pgcli uses its value as
the pager. If it is commented out, then pgcli will use the
Once pgcli is started, you can use the
\pager command to change which pager
> \pager less PAGER set to less.
On macOS and Linux, the pager will default to
less for most users.
sometimes has less-than-desirable behavior like clearing the screen, cutting
lines off, etc. You can configure
less through environment variables in your
shell configuration files. Here are some common
less options and
-Xleaves file contents on the screen when less exits.
lessquit if the entire output can be displayed on one screen.
-Rdisplays ANSI color escape sequences in "raw" form.
-Sdisables line wrapping. Side-scroll to see long lines.
# This is a popular option among pgcli users. export LESS="-XFR" # Some pgcli users like to disable line wrapping. export LESS="-SRXF"