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

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Darrin Ladd <dladd(at)newfoundcomm(dot)net>
Cc: Stuart Foster <stuartafoster(at)home(dot)com>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: How can I select all of the tables with field name 'area'?
Date: 2000-09-12 00:34:27
Message-ID: 39BD7A13.82079EF3@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks Darrin and Stuart.

-Tony

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

Browse pgsql-sql by date

  From Date Subject
Next Message Hector Banda 2000-09-12 00:53:38 This is A test Please Delete
Previous Message Stuart Foster 2000-09-11 23:56:48 RE: How can I select all of the tables with field name 'area'?