pgoptions syntax?

От:

"Fernando Fontana" <fernando.fontana@gmail.com>

Дата:

22 апреля 2008 г. в 15:45:43

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.
regards

Re: pgoptions syntax?

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

22 апреля 2008 г. в 20:59:14

"Fernando Fontana"  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