PostgreSQL Pager OFF

postgresql

This is a useful but difficult-to-remember command for PSQL:

\pset pager off

Or, if the invocation of psql is within control, add the -P pager=off argument:

psql -P pager=off ...

This turns off a “more” type of feature when displaying long results to allow paging up and down the results.

Unlike when using text-base terminals, most terminals nowadays are in a GUI shell with scroll buffers. We can scroll back and forward just fine, thank you very much.