Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.10.1/8.10.1) with ESMTP id e8BNgY714129 for ; Mon, 11 Sep 2000 19:42:36 -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 QAA08921 for ; Mon, 11 Sep 2000 16:42:27 -0700 (PDT) Message-ID: <39BD6CC6.386A1F09@nsi.edu> Date: Mon, 11 Sep 2000 16:37:43 -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: "pgsql-sql@postgreSQL.org" Subject: How can I select all of the tables with field name 'area'? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/70 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