Postgres Pro
Downloads
Home   >   mailing lists

Re: OID of type by name. - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: OID of type by name.
Date
Msg-id AANLkTimGjtBerWed+FGAr8SZjZZDRugKCZRrtXYvOGtz@mail.gmail.com
Whole thread Raw
In response to OID of type by name.  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: OID of type by name.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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 <dmitigr@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.


pgsql-general by date:

Previous
From: Jon Nelson
Date:
Subject: Re: How to obtain the maximum value of a date, between 3 tables...
Next
From: c k
Date:
Subject: Asynchronous query execution