Re: OID of type by name.

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(at)gmail(dot)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.