Robert Haas <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
