Re: [GENERAL] A couple of LIBPQ questions - Mailing list pgsql-general

From Bruce Tong
Subject Re: [GENERAL] A couple of LIBPQ questions
Date
Msg-id Pine.LNX.3.95.980608093812.1031A-100000@laxmi.ev.net
Whole thread Raw
In response to Re: [GENERAL] A couple of LIBPQ questions  (Marin D <marin@cybernet.bg>)
List pgsql-general
> > (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@laxmi.ev.net
http://www.ev.net/fitne


pgsql-general by date:

Previous
From: "Jose' Soares Da Silva"
Date:
Subject: Re: [GENERAL] Missing SQL Syntax & Problem with Create Table
Next
From: Bruce Tong
Date:
Subject: Re: [GENERAL] A couple of LIBPQ questions