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@asa.de>
To: <pgsql-php@postgresql.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