Re: OID of type by name.

[Dmitriy Igrishin <dmitigr@xxxxxxxxx>]

Actually, all I need is to:

SELECT oid::regtype, oid FROM pg_type WHERE ...

to make cache of OIDs.

2010/12/8 Dmitriy Igrishin <dmitigr@xxxxxxxxx>

Yeah, thank you very much!

I've found it already too, but not post back!

Thanks!

2010/12/8 Tom Lane <tgl@xxxxxxxxxxxxx>

Dmitriy Igrishin <dmitigr@xxxxxxxxx> writes:
>> How can I get OID by name rather than alias ?

> SELECT oid FROM pg_type WHERE typtype = 'b' AND typarray <> 0 AND
> typname::regtype = 'integer';

Seems like the hard way --- if you think carefully about what regtype
is doing, you'll realize that this is incredibly inefficient, as well
as a lot of typing. ÂI usually do SELECT 'integer'::regtype::oid
when I need a quick numeric lookup.

           Âregards, tom lane

--
// Dmitriy.

-- 
// Dmitriy.