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 C128FD1E925 for ; Mon, 1 Mar 2004 11:30:21 +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 80082-07 for ; Mon, 1 Mar 2004 07:30:11 -0400 (AST) Received: from majolee.info (unknown [69.46.25.212]) by svr1.postgresql.org (Postfix) with ESMTP id AC7C1D1E90C for ; Mon, 1 Mar 2004 07:30:07 -0400 (AST) Received: from MAJOLEE1 [220.224.35.121] by majolee.info with ESMTP (SMTPD32-8.05) id AEA816010C; Mon, 01 Mar 2004 16:59:44 +0530 Message-ID: <000c01c3ff82$1aa1d270$0100a8c0@MAJOLEE1> From: "Majolee InfoTech" To: "Wim Paulussen" Cc: References: <404317E9.2050004@chen.be> Subject: Re: get list of databases and tables in Postgres Date: Mon, 1 Mar 2004 17:11:06 +0530 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/3 X-Sequence-Number: 2602 Use: select datname from pg_database; =============== Mihir & Biren Partners Majolee InfoTech =============== ----- Original Message ----- From: "Wim Paulussen" To: Sent: Monday, March 01, 2004 4:30 PM Subject: [PHP] get list of databases and tables in Postgres > 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. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > >