Actually, all I need is to: SELECT oid::regtype, oid FROM pg_type WHERE ...
to make cache of OIDs. 2010/12/8 Dmitriy Igrishin <[email protected]> > Yeah, thank you very much! > > I've found it already too, but not post back! > > Thanks! > > 2010/12/8 Tom Lane <[email protected]> > > Dmitriy Igrishin <[email protected]> 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.
