Re: [GENERAL] A couple of LIBPQ questions

> > (1) PQftype() returns a value of type "Oid", but I haven't been able to
> > find a list of what those values might be. I noticed in the header files a
> > value of zero is considered invalid, but that's it. The docs I've found
> > don't tell me anything other than it an integer code representing the
> > type. What are the possible values?
>
> select oid,* from pg_type where oid = <type_oid>
>
> where <type_oid> is between 16 and 32

Thats interesting. How in the world did you ever know to look there?

> > (3) The third paramter to PQsetdb() is pgoptions. I've not found any
> > description of what these options might be. Where can I find a list of the
> > options?
>
> The source says this is for setting backend options for this connection.
>
> man postgres
>
> to see the backend options.

Ahhh, I see. Boy I feel dumb for not having made that connection.

Bruce Tong
Systems Programmer
Electronic Vision / FITNE

mailto: zztong(at)laxmi(dot)ev(dot)net
http://www.ev.net/fitne