From: | "Majolee InfoTech" <info(at)majolee(dot)info> |
---|---|
To: | "Wim Paulussen" <wim(at)chen(dot)be> |
Cc: | <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: get list of databases and tables in Postgres |
Date: | 2004-03-01 11:41:06 |
Message-ID: | 000c01c3ff82$1aa1d270$0100a8c0@MAJOLEE1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Use:
select datname from pg_database;
===============
Mihir & Biren
Partners
Majolee InfoTech
===============
----- Original Message -----
From: "Wim Paulussen" <wim(at)chen(dot)be>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Monday, March 01, 2004 4:30 PM
Subject: [PHP] get list of databases and tables in Postgres
> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Boget | 2004-03-01 14:29:28 | Re: get list of databases and tables in Postgres |
Previous Message | Wim Paulussen | 2004-03-01 11:00:57 | get list of databases and tables in Postgres |