RE: How can I select all of the tables with field name 'area'?

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@hub.org [mailto:pgsql-sql-owner@hub.org]On Behalf
Of G. Anthony Reina
Sent: Monday, September 11, 2000 4:38 PM
To: pgsql-sql@postgreSQL.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