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 27738D1E2E6 for ; Mon, 1 Mar 2004 14:30:27 +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 39865-07 for ; Mon, 1 Mar 2004 10:30:27 -0400 (AST) Received: from puma.wild.net (smtp2.wild.net [208.207.88.10]) by svr1.postgresql.org (Postfix) with ESMTP id 43B5DD1DAB9 for ; Mon, 1 Mar 2004 10:30:22 -0400 (AST) Received: from entropy (entropy.wild.net [192.168.1.140]) by puma.wild.net (8.12.9/8.12.9) with SMTP id i21ETVv0027806; Mon, 1 Mar 2004 08:30:03 -0600 Message-ID: <007801c3ff99$b29452d0$8c01a8c0@entropy> From: "Chris Boget" To: "Majolee InfoTech" , "Wim Paulussen" Cc: References: <404317E9.2050004@chen.be> <000c01c3ff82$1aa1d270$0100a8c0@MAJOLEE1> Subject: Re: get list of databases and tables in Postgres Date: Mon, 1 Mar 2004 08:29:28 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/4 X-Sequence-Number: 2603 > select datname from pg_database; Or simply: \d unless I'm missing something... Chris