Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com
 [216.136.173.58])
	by postgresql.org (Postfix) with SMTP id F0D694758F1
	for <pgsql-sql@postgresql.org>; Thu, 11 Jul 2002 14:39:04 -0400 (EDT)
Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with
	plain)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 11 Jul 2002 18:38:43 -0000
Message-ID: <3D2DD0B0.3EE1E369@Yahoo.com>
Date: Thu, 11 Jul 2002 14:38:40 -0400
From: Jan Wieck <JanWieck@Yahoo.com>
X-Mailer: Mozilla 4.79 [en] (X11; U; Linux 2.2.14-6.1.1smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Steve Brett <SBrett@e-mis.com>
Cc: Stephane Schildknecht <sschildknecht@aurora-linux.com>,
	"Pgsql-Sql (E-mail)" <pgsql-sql@postgresql.org>
Subject: Re: list of tables ? -update to question ...
References: <C05E7DA1218ED411BF8A00105AC95A8E05B0F710@sv-cntrmail.emis.local>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/167
X-Sequence-Number: 8546

Steve Brett wrote:
> 
> sorry ... i didn't make myself clear ...
> 
> i have of course come across \dt before ...
> 
> what i meant was via sql as in 'select tablelist from <some pg sys table
> perhaps ?>'

What about:

SELECT * FROM pg_tables;


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #