Postgres Pro
Downloads
Home   >   mailing lists

RE: How can I select all of the tables with field name 'area'? - Mailing list pgsql-sql

From Stuart Foster
Subject RE: How can I select all of the tables with field name 'area'?
Date
Msg-id LOBBJCEMCNNHMFAJGBOPAELFCDAA.stuartafoster@home.com
Whole thread Raw
In response to How can I select all of the tables with field name 'area'?  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: How can I select all of the tables with field name 'area'?
Next
From: "Darrin Ladd"
Date:
Subject: Re: How can I select all of the tables with field name 'area'?