Re: find column OID types with information schema? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: find column OID types with information schema?
Date
Msg-id 20090427161956.GZ10358@alvh.no-ip.org
Whole thread Raw
In response to find column OID types with information schema?  (Whit Armstrong <armstrong.whit@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: PostgreSQL Object-Oriented Database?
Next
From: Bruce Momjian
Date:
Subject: Re: Cannot reattach to shared memory / Windows