Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D6AE94769F7
	for <pgsql-sql@postgresql.org>; Tue,  7 Jan 2003 05:46:32 -0500 (EST)
Received: from samal.infophil.com (unknown [202.57.89.89])
	by postgresql.org (Postfix) with ESMTP id 1AAD847685B
	for <pgsql-sql@postgresql.org>; Tue,  7 Jan 2003 05:46:32 -0500 (EST)
Received: from infophil.com (samal.hq.infophil.com [192.168.0.14])
	by samal.infophil.com (Postfix) with ESMTP id 290851874D
	for <pgsql-sql@postgresql.org>; Tue,  7 Jan 2003 18:46:40 +0800 (PHT)
Message-ID: <3E1AB00F.1040207@infophil.com>
Date: Tue, 07 Jan 2003 18:46:39 +0800
From: alviN <gamboa@infophil.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: SQL list table names
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/49
X-Sequence-Number: 10914

is it possible to execute an sql query to be able to list the tables's 
names?
well, you can do it on psql using \dt. but im talking about the SQL 
statement, because i want to execute that query from a script.

thanks.



alviN