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

Reply via email to