<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.113 2004/04/2201:53:17 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.114 2004/04/2214:33:38 momjian Exp $

PostgreSQL documentation

-->

<term><option>--no-psqlrc</></term>

<listitem>

<para>

Do not read the start-up file <filename>/psql.rc</filename> or

Do not read the start-up file <filename>/psqlrc</filename> or

<filename>~/.psqlrc</filename>.

</para>

</listitem>

The autocommit-on mode is <productname>PostgreSQL</>'s traditional

behavior, but autocommit-off is closer to the SQL spec. If you

prefer autocommit-off, you may wish to set it in the system-wide

<filename>psql.rc</filename> or your

<filename>psqlrc</filename> or your

<filename>.psqlrc</filename> file.

</para>

</note>

<para>

Before starting up, <application>psql</application> attempts to

read and execute commands from the the system-wide

<filename>psql.rc</filename> file and the

<filename>psqlrc</filename> file and the

<filename>$HOME/.psqlrc</filename> file in the user's home

directory. See <filename><replaceable>PREFIX</>/share/psql.rc.sample</>

directory. See <filename><replaceable>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 <command>\set

</command> and <command>SET</command> commands).

install: all installdirs

$(INSTALL_PROGRAM) psql$(X)$(DESTDIR)$(bindir)/psql$(X)

$(INSTALL_DATA)$(srcdir)/psql.rc.sample$(DESTDIR)$(datadir)/psql.rc.sample

$(INSTALL_DATA)$(srcdir)/psqlrc.sample$(DESTDIR)$(datadir)/psqlrc.sample

installdirs:

-- This file is read before the .psqlrc file in the user's home directory.

--

-- Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and

-- rename itpsql.rc.

-- rename itpsqlrc.

PsqlSettingspset;

#definePSQLRC ".psqlrc"

#defineSYSPSQLRC"psql.rc"

#defineSYSPSQLRC"psqlrc"