Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.10.1/8.10.1) with ESMTP id e8C0dMf26146 for ; Mon, 11 Sep 2000 20:39:22 -0400 (EDT) Received: from nsi.edu (o21.nsi.edu [204.128.156.216]) by nsi.edu (8.9.1/8.9.1) with ESMTP id RAA09967; Mon, 11 Sep 2000 17:39:11 -0700 (PDT) Message-ID: <39BD7A13.82079EF3@nsi.edu> Date: Mon, 11 Sep 2000 17:34:27 -0700 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.72 [en] (X11; U; IRIX 6.5 IP32) X-Accept-Language: en MIME-Version: 1.0 To: Darrin Ladd CC: Stuart Foster , pgsql-sql@postgreSQL.org Subject: Re: How can I select all of the tables with field name 'area'? References: <015e01c01c56$f24be840$0e040a0a@dirge.NEWFOUND> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/74 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'. > >