Re: how are the oids or arrays defined? - 11-10-2006 , 02:57 AM
Sascha Bohnenkamp <bohnenkamp (AT) mevisbreastcare (DOT) de> wrote:
Unfortunately the only array type that has a #define for its OID is
The name of the type for int4 is '_int4', for bytea it is '_bytea' etc.
You can query the table pg_catalog.pg_type for the information you want:
select oid from pg_catalog.pg_type where typname='_int4';
These OIDs are the same for all PostgreSQL servers.
I think that it is theoretically possible that they may change from one
PostgreSQL version to the other, but I don't think that this will ever