Received: from mail.fiber.net (mail.fiber.net [216.83.130.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA1EdDl59143 for ; Wed, 1 Nov 2000 09:39:13 -0500 (EST) (envelope-from dan_wilson@geocities.com) Received: from danwilson (bbudnick.employees.fiber.net [216.83.131.7]) by mail.fiber.net (8.9.3/8.9.3) with SMTP id HAA22921; Wed, 1 Nov 2000 07:38:50 -0700 (MST) Message-ID: <000b01c04419$bc8ef310$078353d8@danwilson> From: "Dan Wilson" To: "magnus" , References: <3A0030A1.81831A88@asa.de> Subject: Re: listing databases Date: Wed, 1 Nov 2000 07:38:06 -0800 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.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200011/4 X-Sequence-Number: 12 Databases: SELECT datname FROM pg_databases Tables: SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg%' The "NOT LIKE 'pg%'" filters out the system tables. If you are interested in learning more about the system tables, you can download my phpPgAdmin (http://www.phpwizard.net/projects/phpPgAdmin) and view the source code. I have to use the system tables for almost everything. If you do not want to download it, you can check out the source code through the snapshot page (http://pgdemo.acucore.com/snapshot). -Dan Wilson ----- Original Message ----- From: "magnus" To: Sent: Wednesday, November 01, 2000 7: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