Re: find column OID types with information schema?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:38:39
Message-ID: 4697.1240846719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Whit Armstrong <armstrong(dot)whit(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael P. Soulier 2009-04-27 15:56:51 Re: how do you get there from here?
Previous Message Robert Pepersack 2009-04-27 15:38:18 Re: PostgreSQL Object-Oriented Database?