get list of databases and tables in Postgres

From: Wim Paulussen <wim(at)chen(dot)be>
To: pgsql-php(at)postgresql(dot)org
Subject: get list of databases and tables in Postgres
Date: 2004-03-01 11:00:57
Message-ID: 404317E9.2050004@chen.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

LS,

Hope you can help : I am looking for equivalent sql statement for the
following in MySQL :
SHOW DATABASES

I found out that for the tables you can connect to a Postgresql specific
table information_schema.tables , but what is the corresponding table
for the names of databases under Postgresql ?

All help is highly appreciated.

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Majolee InfoTech 2004-03-01 11:41:06 Re: get list of databases and tables in Postgres
Previous Message Michael Glaesemann 2004-03-01 09:31:52 SQLSTATE in PHP?