"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