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 13053D1D313 for ; Mon, 1 Mar 2004 11:01:15 +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 58088-10 for ; Mon, 1 Mar 2004 07:00:59 -0400 (AST) Received: from nebula.skynet.be (nebula.skynet.be [195.238.2.112]) by svr1.postgresql.org (Postfix) with ESMTP id 67475D1B4E7 for ; Mon, 1 Mar 2004 07:00:55 -0400 (AST) Received: from chen.be (17.252-200-80.adsl-fix.skynet.be [80.200.252.17]) by nebula.skynet.be (8.12.9/8.12.9/Skynet-OUT-2.21) with ESMTP id i21B0n2U012462 for ; Mon, 1 Mar 2004 12:00:50 +0100 (envelope-from ) Message-ID: <404317E9.2050004@chen.be> Date: Mon, 01 Mar 2004 12:00:57 +0100 From: Wim Paulussen User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: get list of databases and tables in Postgres Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-RAVMilter-Version: 8.4.3(snapshot 20030212) (nebula.skynet.be) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/2 X-Sequence-Number: 2601 LS, Hope you can help : I am looking for equivalent sql statement for the following in MySQL : SHOW DATABASES I found out that for the tables you can connect to a Postgresql specific table information_schema.tables , but what is the corresponding table for the names of databases under Postgresql ? All help is highly appreciated.