On Wed, Jun 16, 2010 at 10:42 PM, zhong ming wu <mr.z.m.wu@xxxxxxxxx> wrote: > Dear List > > Where can I find this mapping of oid to pg data types mentioned in > libpq documentation? > Why is such information not mentioned in the documentation? A general > knowledge? curious: what do you need the oids for? built in type oids are defined in pg_type.h: cat src/include/catalog/pg_type.h | grep OID | grep define built in type oids don't change. you can pretty much copy/pasto the output of above into an app...just watch out for some types that may not be in older versions. user defined type oids (tables, views, composite types, enums, and domains) have an oid generated when it is created. since that oid can change via ddl so you should look it up by name at appropriate times. if you want to be completely abstracted from the type oids, look here: http://libpqtypes.esilo.com/ merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
