Postgres Pro
Downloads
Home   >   mailing lists

get list of databases and tables in Postgres - Mailing list pgsql-php

From Wim Paulussen
Subject get list of databases and tables in Postgres
Date
Msg-id 404317E9.2050004@chen.be
Whole thread Raw
List pgsql-php
Tree view 
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.

pgsql-php by date:

Previous
From: Michael Glaesemann
Date:
Subject: SQLSTATE in PHP?
Next
From: "Majolee InfoTech"
Date:
Subject: Re: get list of databases and tables in Postgres