How to disable the pager in PostgreSQL

PostgreSQL uses a pager to display the results of an operation you performed when you are using the command line tool (psql).

You can disable the pager by issuing:

pset pager off

with which you specifically request that the pager is disabled. You can re-enable the pager by issuing:

pset pager on

with which you specifically request that the pager is enabled. Alternatively you can toggle the status of the pager by issuing

pset pager

which depending on the current status of the pager will either enable or disable it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s