Re: find column OID types with information schema?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: find column OID types with information schema?
Date: 2009-04-27 16:19:56
Message-ID: 20090427161956.GZ10358@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Whit Armstrong escribió:
> Is it possible to find out the OID types of the columns of a table
> using the information schema?

No; information_schema is limited to stuff that's defined by the SQL
standard. If you want OIDs, you need to extract that stuff from the
pg_catalog.* catalogs.

Type OIDs for attributes can be found in pg_attribute.atttypid.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-04-27 16:22:06 Re: Cannot reattach to shared memory / Windows
Previous Message Bill Moran 2009-04-27 16:14:03 Re: PostgreSQL Object-Oriented Database?