Received: from web9503.mail.yahoo.com (web9503.mail.yahoo.com [216.136.129.133]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eA1F7Wl62008 for ; Wed, 1 Nov 2000 10:07:33 -0500 (EST) (envelope-from killroyboy@yahoo.com) Message-ID: <20001101150721.15601.qmail@web9503.mail.yahoo.com> Received: from [205.172.150.137] by web9503.mail.yahoo.com; Wed, 01 Nov 2000 07:07:21 PST Date: Wed, 1 Nov 2000 07:07:21 -0800 (PST) From: Dan Wilson Reply-To: dan_wilson@geocities.com Subject: Re: listing databases To: Adam Lang , pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200011/6 X-Sequence-Number: 14 I connect using the default database which is usually template1. But you can access the system tables from a connection into any database. -Dan --- Adam Lang wrote: > So you just connect to the database using username, > password, host, and > port? Don't use a dbname in the connection string? > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "Dan Wilson" > To: "magnus" ; > > Sent: Wednesday, November 01, 2000 10:38 AM > Subject: Re: [PHP] listing databases > > > > 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 > __________________________________________________ Do You Yahoo!? From homework help to love advice, Yahoo! Experts has your answer. http://experts.yahoo.com/