Like a charm. Thanks! -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Wednesday, December 07, 2011 9:57 AM To: pgsql-general@xxxxxxxxxxxxxx Cc: Gauthier, Dave Subject: 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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
