SELECT oid FROM pg_type WHERE typtype = 'b' AND typarray <> 0 AND typname::regtype = 'integer';
Many thanks to Florian Pflug. 2010/12/8 Dmitriy Igrishin <dmit...@gmail.com> > Hey general@, > > SELECT oid FROM pg_type WHERE typname = 'integer'; > oid > ----- > (0 rows) > > SELECT oid FROM pg_type WHERE typname = 'int4'; > oid > ----- > 23 > (1 row) > > How can I get OID by name rather than alias ? > > -- > // Dmitriy. > > > -- // Dmitriy.