Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitriy Igrishin
Subject OID of type by name.
Date
Msg-id AANLkTimE-5neT6QYNxkmDri+zAZuhexbrJHh9gn7Ld=c@mail.gmail.com
Whole thread Raw
Responses Re: OID of type by name.  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Tree view
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.


pgsql-general by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: Abusing Postgres in fun ways.
Next
From: Andre Lopes
Date:
Subject: How to obtain the maximum value of a date, between 3 tables...