Re: listing databases

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" <dan_wilson(at)geocities(dot)com>
To: "magnus" <reduct(at)asa(dot)de>; <pgsql-php(at)postgresql(dot)org>
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" <reduct(at)asa(dot)de>
> To: <pgsql-php(at)postgresql(dot)org>
> 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