Thread: options in conninfo

Hi,

Using libpq PQconnect function, what is the syntax for the 'options' 
entry in the conninfo?  I think the docs should be updated to give an 
example..

http://www.postgresql.org/docs/8.0/interactive/libpq.html#LIBPQ-CONNECT

Thanks,

Chris

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Using libpq PQconnect function, what is the syntax for the 'options' 
> entry in the conninfo?

I think it's stuck straight into the backend command line, so whatever
you read in the 'postgres' reference page applies.

> I think the docs should be updated to give an example..

Send a patch...
        regards, tom lane

>>Using libpq PQconnect function, what is the syntax for the 'options' 
>>entry in the conninfo?
> 
> 
> I think it's stuck straight into the backend command line, so whatever
> you read in the 'postgres' reference page applies.

Oh, I thought it was for setting GUCs at connect time.  Is that 
possible? I thought it was in the new protocol, but I just cannot find 
the docs on it...

Chris

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>>> Using libpq PQconnect function, what is the syntax for the 'options' 
>>> entry in the conninfo?

>> I think it's stuck straight into the backend command line, so whatever
>> you read in the 'postgres' reference page applies.

> Oh, I thought it was for setting GUCs at connect time.  Is that 
> possible? I thought it was in the new protocol, but I just cannot find 
> the docs on it...

No, the 'options' thing is exceedingly ancient.  Try something likePGOPTIONS="-fn" psql mydb
or equivalentlyPGOPTIONS="-c enable-mergejoin=false" psql mydb

The GUC-at-connect-time feature is new in the V3 protocol.  Offhand I do
not think libpq exposes that to its users; it does use it internally
IIRC.
        regards, tom lane