Need a SQL to find if table has OIDS

From: Francisco Leovey <fleovey(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Need a SQL to find if table has OIDS
Date: 2011-06-13 11:58:29
Message-ID: 716448.17809.qm@web39303.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello group
 
Using Postgres 9.0.3
 
I need a SQL statement that will tell me if a given table is defined  WITH (OIDS=TRUE)
I am able to get column names, data types, etc but this eludes me.
 
Thank you

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2011-06-13 13:28:32 Re: Need a SQL to find if table has OIDS
Previous Message Mike Adams 2011-06-13 02:49:07 Re: table design