Re: pgoptions syntax?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fernando Fontana" <fernando(dot)fontana(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pgoptions syntax?
Date: 2008-04-22 23:59:00
Message-ID: 29323.1208908740@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Fernando Fontana" <fernando(dot)fontana(at)gmail(dot)com> writes:
> what's the syntax of the PGOPTIONS environment variable?
> I'm trying to put something like 'autocommit=off', but more generally
> I want to know all the options that it has.

It's the same as command line options for the postgres executable,
eg "--autocommit=off" (or "-c autocommit=off" if you have a version
of getopt() that can't handle the former).

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Didier Gasser-Morlay 2008-04-23 05:28:02 Re: Client connection lost; still in the task list
Previous Message Fernando Fontana 2008-04-22 18:45:31 pgoptions syntax?