OID of type by name.

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: OID of type by name.
Date: 2010-12-08 11:55:05
Message-ID: AANLkTimE-5neT6QYNxkmDri+zAZuhexbrJHh9gn7Ld=c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre Lopes 2010-12-08 13:15:41 How to obtain the maximum value of a date, between 3 tables...
Previous Message tv 2010-12-08 10:58:57 Re: Abusing Postgres in fun ways.