Robert Haas <robertmhaas@gmail.com> writes:
> Well then we need a reliable way to identify a type. What would satisfy you?
An oid ?
=# select objid from pg_extension_objects('hstore') where class = 'pg_type'::regclass and objdesc
~'(^|\.)hstore$';objid
-------16387
(1 row)
You have 4 types in there so you want to be somewhat careful here…
=# select * from pg_extension_objects('hstore') where class = 'pg_type'::regclass; class | classid | objid |
objdesc
---------+---------+-------+----------------------pg_type | 1247 | 16387 | type utils.hstorepg_type | 1247 |
16392| type utils.hstore[]pg_type | 1247 | 16466 | type utils.ghstorepg_type | 1247 | 16469 | type
utils.ghstore[]
(4 rows)
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support