psql, the command line PostgreSQL tool is great. By default if the output of some command (or query) takes too much screen space, psql will use your default unix terminal pager to page through results.

Sometimes you want to turn this off. This can happen if you want to see the output of 2 commands in one screen, and one (or both) of the commands invokes the pager. In cases like this it's better for you to put up with a bit of word wrapping so that you can see what's going on.

To turn it off just enter the following command in the psql prompt:

\pset pager

This will toggle the pager. Do it once and the pager will be off.