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

From Joachim Wieland
Subject Re: Basic questions about PQprepare()
Date
Msg-id 20060129170341.GA4808@mcknight.de
Whole thread Raw
In response to Re: Basic questions about PQprepare()  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Basic questions about PQprepare()  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Alexander,

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

You can select it like any other table:

select oid, typname from pg_type;

(You might want to restrict the list to non-composite types by adding a
"where typrelid = 0")


> There are really not many PQprepare examples
> around (I wonder why, isn't it the fastest method?)

It depends on the query complexity and in how often you want to execute the
same query with different arguments.

You're always welcome to improve the documentation by submitting a
documentation patch that adds more examples  ;-)


Joachim

--
Joachim Wieland                                              joe@mcknight.de
C/ Usandizaga 12 1°B                                           ICQ: 37225940
20002 Donostia / San Sebastian (Spain)                     GPG key available

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: creating users per database
Next
From: "Raymond O'Donnell"
Date:
Subject: Re: help