Re: OID of type by name.

[Dmitriy Igrishin <dmitigr@xxxxxxxxx>]

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@xxxxxxxxx>

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.