Re: OID of type by name.

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

> Yeah, thank you very much!
>
> I've found it already too, but not post back!
>
> Thanks!
>
> 2010/12/8 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
> Dmitriy Igrishin <dmitigr(at)gmail(dot)com> 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.