Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: find column OID types with information schema?
Date
Msg-id 4697.1240846719@sss.pgh.pa.us
Whole thread Raw
In response to find column OID types with information schema?  (Whit Armstrong <armstrong.whit@gmail.com>)
List pgsql-general
Tree view 
Whit Armstrong <armstrong.whit@gmail.com> writes:
> Is it possible to find out the OID types of the columns of a table
> using the information schema?

No.  Type OIDs are a Postgres-ism so they are not reflected in the
standards-mandated contents of the information_schema.  If you want
OIDs you'll need to look at the underlying catalogs (pg_attribute
in particular).

            regards, tom lane

pgsql-general by date:

Previous
From: "Robert Pepersack"
Date:
Subject: Re: PostgreSQL Object-Oriented Database?
Next
From: "Michael P. Soulier"
Date:
Subject: Re: how do you get there from here?