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
<dmitigr@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.