PSQL 8.3+ client query results display
You can also disable it when you start up psql:
$ psql -U admin db_name --pset pager=off
If you always want it to be off, you can add this to your .bashrc
file:
alias psql='psql --pset pager=off'
in addition to \pset pager always
add the following in your .profile (or .bashrc)
export PAGER=less
export LESS="-iMSx4 -FX"
\pset pager off
\pset pager on
\pset pager always
Alternatively, configure the pager to your liking.