Re: Basic questions about PQprepare()

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