Received: from mail.rdc1.az.home.com (imail@ha1.rdc1.az.home.com [24.1.240.66]) by hub.org (8.10.1/8.10.1) with ESMTP id e8BNwH717209 for ; Mon, 11 Sep 2000 19:58:17 -0400 (EDT) Received: from renne ([24.16.143.93]) by mail.rdc1.az.home.com (InterMail vM.4.01.02.00 201-229-116) with SMTP id <20000911235816.DNGZ12685.mail.rdc1.az.home.com@renne>; Mon, 11 Sep 2000 16:58:16 -0700 From: "Stuart Foster" To: "G. Anthony Reina" , Subject: RE: How can I select all of the tables with field name 'area'? Date: Mon, 11 Sep 2000 16:56:48 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <39BD6CC6.386A1F09@nsi.edu> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal X-Archive-Number: 200009/71 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