Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA1EIml58206 for ; Wed, 1 Nov 2000 09:18:48 -0500 (EST) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id JAA04354 for ; Wed, 1 Nov 2000 09:23:54 -0500 Message-ID: <00b001c0440e$fd1f6d20$330a0a0a@6014cwpza006> From: "Adam Lang" To: References: <3A0030A1.81831A88@asa.de> Subject: Re: listing databases Date: Wed, 1 Nov 2000 09:21:13 -0500 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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/2 X-Sequence-Number: 10 I don't know of a way. To connect to postgresql I think it is mandatory to include the dbname. Even if you didn't, there is no function that lists the DBs on the system. Unfortunately that is something MySQL in PHP has. You can connect to jsut the Server, and it has a function called mysql_list_dbs which returns a result set of databases on the server. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "magnus" To: Sent: Wednesday, November 01, 2000 10:02 AM Subject: [PHP] listing databases > Hello, > Can anyone tell me how to list (1.) databases and (2.) tables in a > database using php? > Thanks, > Magnus Lawrie