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 A28F152BCA
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Jul 2005 19:24:48 -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 11951-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Jul 2005 22:24:47 +0000 (GMT)
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id DB9A252BC2
	for <pgsql-sql@postgresql.org>; Thu, 14 Jul 2005 19:24:46 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 112CC30B42; Fri, 15 Jul 2005 00:30:00 +0200 (MET DST)
From: sunny076@yahoo.com
X-Newsgroups: pgsql.sql
Subject: How to obtain the list of data table name only
Date: 14 Jul 2005 15:24:42 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1121379882.854728.128920@z14g2000cwz.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Complaints-To: groups-abuse@google.com
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=66.60.142.42;
	posting-account=LbpMzw0AAAAg9L7FCnVmhfI0NDnqPgtI
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.804 tagged_above=0 required=5 tests=AWL,
	FORGED_YAHOO_RCVD, FROM_ENDS_IN_NUMS, NO_REAL_NAME
X-Spam-Level: **
X-Archive-Number: 200507/125
X-Sequence-Number: 22103

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