Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group