Search Postgresql Archives

Re: Basic questions about PQprepare()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx
C/ Usandizaga 12 1°B                                           ICQ: 37225940
20002 Donostia / San Sebastian (Spain)                     GPG key available


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux