Robert Haas <robertmh...@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.hstore pg_type | 1247 | 16392 | type utils.hstore[] pg_type | 1247 | 16466 | type utils.ghstore pg_type | 1247 | 16469 | type utils.ghstore[] (4 rows) Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers