X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B1DEDD1D2BA for ; Mon, 1 Mar 2004 22:31:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27571-05 for ; Mon, 1 Mar 2004 18:31:48 -0400 (AST) Received: from dnscache2.syd.nexon.com.au (dnscache2.syd.nexon.com.au [210.215.48.100]) by svr1.postgresql.org (Postfix) with ESMTP id AD5BAD1D182 for ; Mon, 1 Mar 2004 18:31:45 -0400 (AST) Received: from chris ([210.215.130.98]) by dnscache2.syd.nexon.com.au (8.12.8p1/8.12.8) with ESMTP id i21JSvpl025880; Tue, 2 Mar 2004 06:28:58 +1100 (EST) (envelope-from chris@interspire.com) From: "Chris Smith" To: "'Chris Boget'" , "'Majolee InfoTech'" , "'Wim Paulussen'" Cc: Subject: Re: get list of databases and tables in Postgres Date: Tue, 2 Mar 2004 09:30:49 +1100 Message-ID: <000701c3ffdc$dfb169e0$0d00a8c0@chris> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-reply-to: <007801c3ff99$b29452d0$8c01a8c0@entropy> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/8 X-Sequence-Number: 2607 He wants to do it through PHP - so I don't think this will work. You could always psql -E -l BUT - that query *could* change depending on the version of postgresql you're running. Chris. -----Original Message----- From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Chris Boget Sent: Tuesday, March 02, 2004 1:29 AM To: Majolee InfoTech; Wim Paulussen Cc: pgsql-php@postgresql.org Subject: Re: [PHP] get list of databases and tables in Postgres > select datname from pg_database; Or simply: \d unless I'm missing something... Chris ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html