You should be able to query the system table that holds that column names.
Not sure which it is tho.
-----Original Message-----
From: pgsql-sql-owner(at)hub(dot)org [mailto:pgsql-sql-owner(at)hub(dot)org]On Behalf
Of G. Anthony Reina
Sent: Monday, September 11, 2000 4:38 PM
To: pgsql-sql(at)postgreSQL(dot)org
Subject: [SQL] How can I select all of the tables with field name
'area'?
I have a database with several tables. I'd like to pull out a list of
names for the tables that contain the field (class) name 'area'.
Can this be done?
-Tony