Thanks Darrin and Stuart.
Darrin Ladd wrote:
> Here's what you are looking for:
> SELECT pg_class.relname
> FROM pg_class, pg_attribute
> WHERE pg_attribute.attname = 'area'
> AND pg_attribute.attrelid = pg_class.oid;
> This should give you all of the classes (tables) which have the attribute
> (field) 'area'.
In response to
pgsql-sql by date
|Next:||From: Hector Banda||Date: 2000-09-12 00:53:38|
|Subject: This is A test Please Delete|
|Previous:||From: Stuart Foster||Date: 2000-09-11 23:56:48|
|Subject: RE: How can I select all of the tables with field name 'area'?|