find column OID types with information schema?

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: find column OID types with information schema?
Date: 2009-04-27 15:34:43
Message-ID: 8ec76080904270834i304cfdf5g33ce2ead9bdfff8c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to find out the OID types of the columns of a table
using the information schema?

I see that I can get the character names of the types using this query:

select * from information_schema.columns where table_name = 'my_table';

but I don't see a way to find the actual OID types of the columns. Is
that possible?

Thanks,
Whit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Pepersack 2009-04-27 15:38:18 Re: PostgreSQL Object-Oriented Database?
Previous Message Tom Lane 2009-04-27 15:27:54 Re: how do you get there from here?