Re: Basic questions about PQprepare() - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Basic questions about PQprepare()
Date
Msg-id 20060130030034.GA55649@winnie.fuhr.org
Whole thread Raw
In response to Re: Basic questions about PQprepare()  (Joachim Wieland <joe@mcknight.de>)
Responses Re: Basic questions about PQprepare()  (Keary Suska <hierophant@pcisys.net>)
List pgsql-general
On Sun, Jan 29, 2006 at 06:03:41PM +0100, Joachim Wieland wrote:
> On Sat, Jan 28, 2006 at 08:26:01PM +0100, Alexander Farber wrote:
> > Could you explain a bit more, where to get the OIDs?
>
> They are in the pg_type table, it is described here:
>
> http://www.postgresql.org/docs/8.1/static/catalog-pg-type.html

For standard types you could include server/catalog/pg_type.h and
use TEXTOID, INT4OID, etc.  But as Tom Lane mentioned, if the query
is written so the backend can infer the types then you don't need
to bother.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: creating users per database
Next
From: "Silas Justiniano"
Date:
Subject: Indexes