Ken Been wrote:
> Thanks, but I actually wanted to do it from C code. But anyway I think I
> found the answer: use the symbolic constants in catalog/pg_type.h, such as
> INT4OID.
You can probably use
SearchSysCache1(TYPEOID, ObjectIdGetDatum(your_oid))
or perhaps
lookup_type_cache(your_oid).
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services