customize pager in psql

Question

When I use psql, the command line tool of PostgreSQL, in interactive mode, it lists data as paginated output.

However, because I use psql in a terminal application which can handle long outputs itself, I rather would like to get the whole output without the paginating with the annoying --more-- line.

Is there any way to customise the paging behavior in psql? I tried to set LESS in the surrounding shell environment to cat, but this din't help.

Any suggestions?

score 55 · Accepted Answer · answered Jan 23 '13 at 07:43

55

From the fine psql manual:

\pset option [ value ]
[...]
pager
Controls use of a pager program for query and psql help output. If the environment variable PAGER is set, the output is piped to the specified program. Otherwise a platform-dependent default (such as more) is used.

When the pager option is off, the pager program is not used. When the pager option is on, the pager is used when appropriate

So you can say this from the psql prompt:

psql> \pset pager off

to turn the pager off. If you want this to always apply, you can add \pset pager off to your ~/.psqlrc file.

You can also use \? from the psql prompt to get a quick summary of the special commands at your disposal.

answered Jan 23 '13 at 07:43

mu is too short

426,620
70
833
800

2

Thanks for this. I should have found it myself in the help, but because of the pager I never got to the `\pset` command. ;-) – halloleo Jan 24 '13 at 01:53
2

It is so nice to do this... export PAGER="vim -c 'set nomod nolist syntax=sql' -" and then use psql ...! – Luciano Andress Martini May 11 '18 at 12:39
For anyone coming here years later: `\pset` is case-sensitive!!! – RonJohn Apr 26 '21 at 11:07
1

Just a word to tell that there is apparently no way to force the pager value to **on**. It's either off or "long output". Which is in some case (long field content, low record count) not working properly >_ – Romuald Brunet Aug 06 '21 at 12:46
@RomualdBrunet Maybe `\x auto` would help. – mu is too short Aug 07 '21 at 00:14
Note: if you're using the postgres user, the change to ~/.psqlrc for it to be permanent will not work – Alkanshel Mar 29 '23 at 19:12

score 2 · Answer 2 · answered Jun 27 '19 at 18:40

For completeness we might mention that for a one-off or to use as a setting in one of your scripts... (and as mentioned by "mu", see the psql --help (manual))

As a command in a script

psql --pset=pager-off -c "<sqlCommand>" <databaseName>

From your commandline

psql --pset=pager=off <databaseName>

This would be in effect for the single command only so it is most useful in a script.

You can use this method in lieu of making temporary changes within the psql utility or permanent settings via the init file (~/.psqlrc).

I wonder if the answer given here is for a different version of `psql`. This did not work for me. The following worked for me: `psql -P pager=off `, via https://stackoverflow.com/a/15621397/320399 — blong, Mar 02 '21 at 03:51

customize pager in psql

2 Answers2

Linked