Thread: pgoptions syntax?

pgoptions syntax?

From
"Fernando Fontana"
Date:
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?

From
Tom Lane
Date:
"Fernando Fontana" <fernando.fontana@gmail.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