Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3])
	by postgresql.org (Postfix) with ESMTP id 88CA9475C2A
	for <pgsql-sql@postgresql.org>; Thu, 11 Jul 2002 10:10:29 -0400 (EDT)
Received: from [62.165.4.160] (helo=there)
	by lubitsch.akademie.de with smtp (Exim 3.33 #2)
	id 17SeeP-0003Q9-00; Thu, 11 Jul 2002 16:10:33 +0200
Content-Type: text/plain;
  charset="iso-8859-1"
From: Ian Barwick <barwick@gmx.net>
Organization: akademie.de
To: Steve Brett <SBrett@e-mis.com>,
	"Pgsql-Sql (E-mail)" <pgsql-sql@postgresql.org>
Subject: Re: list of tables ?
Date: Thu, 11 Jul 2002 16:09:41 +0200
X-Mailer: KMail [version 1.3.2]
References: <C05E7DA1218ED411BF8A00105AC95A8E05B0F6C5@sv-cntrmail.emis.local>
In-Reply-To: <C05E7DA1218ED411BF8A00105AC95A8E05B0F6C5@sv-cntrmail.emis.local>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <E17SeeP-0003Q9-00@lubitsch.akademie.de>
X-Archive-Number: 200207/159
X-Sequence-Number: 8538

On Thursday 11 July 2002 16:00, Steve Brett wrote:
> can anyone point me in the right direction ?
>
> i need to list all the tables in a database.
>
> i've looked at pgadmin_tables which is empty and pga_schema whihc contains
> a sinlge row i don't want to parse ...
>
> is there an easier way t get a list of tables ?

Start psql with the -E option and issue \dt

This gives you the statement(s) used internally by psql.


Ian Barwick