X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B03C3D7D07 for ; Thu, 25 Aug 2005 08:13:59 -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 26420-05 for ; Thu, 25 Aug 2005 11:13:55 +0000 (GMT) Received: from ennui.i.digital-scurf.org (haddenham.pepperfish.net [217.168.16.17]) by svr1.postgresql.org (Postfix) with ESMTP id EB2B3D7D8A for ; Thu, 25 Aug 2005 08:13:53 -0300 (ADT) Received: from petitemort.i.digital-scurf.org ([192.168.0.190]) by ennui.i.digital-scurf.org with esmtp (Exim 4.34) id 1E8FgB-0003b8-SI for pgsql-sql@postgresql.org; Thu, 25 Aug 2005 12:13:55 +0100 Subject: table listing queries From: Daniel Silverstone To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: Digital-Scurf Date: Thu, 25 Aug 2005 12:13:55 +0100 Message-Id: <1124968435.18119.1.camel@petitemort.i.digital-scurf.org> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/237 X-Sequence-Number: 22465 Hi, I know that questions like this have been asked in the past, but I can find no definitive answer to one particular part of my problem... Namely, in MySQL I can say: "SHOW TABLES FROM 'dbname'" to list tables in a database I'm not currently connected to. I can find no way of doing this in PgSQL. Is there a way, or is postgres not letting me list the tables until I have connected to the database for security reasons? Thanks in advance, D. -- Daniel Silverstone http://www.digital-scurf.org/ PGP mail accepted and encouraged. Key Id: 2BC8 4016 2068 7895