Re: [GENERAL] OID of type by name.

[Dmitriy Igrishin]

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.