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