Postgres Pro
Downloads
Home   >   mailing lists

Need a SQL to find if table has OIDS - Mailing list pgsql-novice

From Francisco Leovey
Subject Need a SQL to find if table has OIDS
Date
Msg-id 716448.17809.qm@web39303.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Need a SQL to find if table has OIDS  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Mike Adams
Date:
Subject: Re: table design
Next
From: Andreas Kretschmer
Date:
Subject: Re: Need a SQL to find if table has OIDS