\pset pager off

Category: Databases & SQL

\pset pager off

Turn off the pager for long output

Makes psql print results straight to the terminal instead of pausing in less. Useful when you pipe output into other commands. Related: \pset format to change layout.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.