Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group