X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5424A52AA1 for ; Fri, 15 Jul 2005 09:16:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30842-01 for ; Fri, 15 Jul 2005 12:16:19 +0000 (GMT) Received: from mail.iinet.net.au (mail-05.iinet.net.au [203.59.3.37]) by svr1.postgresql.org (Postfix) with SMTP id BD01B52A7E for ; Fri, 15 Jul 2005 09:16:15 -0300 (ADT) Received: (qmail 20146 invoked from network); 15 Jul 2005 12:16:17 -0000 Received: from unknown (HELO 203-166-248-211.dyn.iinet.net.au) (203.166.248.211) by mail.iinet.net.au with SMTP; 15 Jul 2005 12:16:16 -0000 Subject: Re: How to obtain the list of data table name only From: Neil Dugan To: pgsql-sql@postgresql.org In-Reply-To: <1121379882.854728.128920@z14g2000cwz.googlegroups.com> References: <1121379882.854728.128920@z14g2000cwz.googlegroups.com> Content-Type: text/plain Date: Fri, 15 Jul 2005 22:16:08 +1000 Message-Id: <1121429769.4950.3.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/139 X-Sequence-Number: 22117 On Thu, 2005-07-14 at 15:24 -0700, sunny076@yahoo.com wrote: > Hi, > > I am wondering if anyone can tell me how I can obtain only the list of > data table in postgresql without function and other ancillary tables. I > hope that I can add a tag that can filter only data table. > > I am using the following SQL Statement: > > "SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES" > > I would appreciate if anyone can enligten me on how this can be > achieve. > > Sunny I am not sure what you mean but one way to find out what tables there are is to use the 'pg_tables' view. select tablename from pg_tables; Regards Neil.