Re: hstores in pl/python

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