Today I Learned

hashrocket A Hashrocket project

Toggling The Pager In PSQL

When the pager is enabled in psql, commands that produce larger output will be opened in a pager. The pager can be enabled within psql by running \pset pager on.

If you'd like to retain the output of commands, perhaps as reference for subsequent commands, you can turn the pager off. As you might expect, the pager can be disabled with \pset pager off.

source

See More #sql TILs
Looking for help? Hashrocket developers believe that data quality is as important as code quality. We enjoy all the challenges of relational databases, from finding the fastest index, to structuring data to fit the needs of an application. We're eager to share our experiences; check out PG Casts, our series of free PostgreSQL screencasts.