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

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

> select datname from pg_database;

Or simply:

\d

unless I'm missing something...

Chris

Chris Boget wrote:

>>select datname from pg_database;
> Or simply:
> \d
> unless I'm missing something...
> Chris

Would PGSQL respond to that as a query?
--
D. Wokan

using psql
psql -l

=====
Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo(at)yahoo(dot)com(dot)br

______________________________________________________________________

Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
http://br.yahoo.com/info/mail.html

He wants to do it through PHP - so I don't think this will work.

You could always

psql -E -l

BUT - that query *could* change depending on the version of postgresql
you're running.

Chris.

-----Original Message-----
From: pgsql-php-owner(at)postgresql(dot)org
[mailto:pgsql-php-owner(at)postgresql(dot)org] On Behalf Of Chris Boget
Sent: Tuesday, March 02, 2004 1:29 AM
To: Majolee InfoTech; Wim Paulussen
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: [PHP] get list of databases and tables in Postgres

> select datname from pg_database;

Or simply:

\d

unless I'm missing something...

Chris

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

If you're running 7.4, look into the iformation_schema for such things.
That likely won't change.

On Tue, 2 Mar 2004, Chris Smith wrote:

> He wants to do it through PHP - so I don't think this will work.
>
> You could always
>
> psql -E -l
>
> BUT - that query *could* change depending on the version of postgresql
> you're running.
>
> Chris.
>
> -----Original Message-----
> From: pgsql-php-owner(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org] On Behalf Of Chris Boget
> Sent: Tuesday, March 02, 2004 1:29 AM
> To: Majolee InfoTech; Wim Paulussen
> Cc: pgsql-php(at)postgresql(dot)org
> Subject: Re: [PHP] get list of databases and tables in Postgres
>
>
> > select datname from pg_database;
>
> Or simply:
>
> \d
>
> unless I'm missing something...
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>