Like a charm. Thanks!
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Wednesday, December 07, 2011 9:57 AM
To: pgsql-general@postgresql.org
Cc: Gauthier, Dave
Subject: Re: [GENERAL] 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.klaver@gmail.com