Re: making "\pset pager off" the default

On Wednesday, December 07, 2011 6:45:12 am Gauthier, Dave wrote:
> Hi:
>
> How can I make "pager off" the default when running psql ?
>
> v8.3.4 and v9.0.1 on linux.

Use a psqlrc file and add \pset pager off:

http://www.postgresql.org/docs/9.0/interactive/app-psql.html

"
Files

Unless it is passed an -X or -c option, psql attempts to read and execute
commands from the system-wide psqlrc file and the user's ~/.psqlrc file before
starting up. (On Windows, the user's startup file is named
%APPDATA%\postgresql\psqlrc.conf.) See PREFIX/share/psqlrc.sample for
information on setting up the system-wide file. It could be used to set up the
client or the server to taste (using the \set and SET commands).

Both the system-wide psqlrc file and the user's ~/.psqlrc file can be made
version-specific by appending a dash and the PostgreSQL release number, for
example ~/.psqlrc-9.0.6. A matching version-specific file will be read in
preference to a non-version-specific file.

The command-line history is stored in the file ~/.psql_history, or
%APPDATA%\postgresql\psql_history on Windows.
'

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com