Re: 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