This section needs to be converted from the original psql man page. Volunteers? To change the paging behavior of your results, set/unset your PAGER environment variable. From Brett McCormick on the mailing list 1998-04-04. To affect the paging behavior of your psql output, set or unset your PAGER environment variable. I always have to set mine before it will pause. And of course you have to do this before starting the program. In csh/tcsh or other C shells: unsetenv PAGER while in sh/bash or other Bourne shells: unset PAGER