Thread: 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@chen.be> To: <pgsql-php@postgresql.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@yahoo.com.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@postgresql.org
[mailto:pgsql-php-owner@postgresql.org] On Behalf Of Chris Boget
Sent: Tuesday, March 02, 2004 1:29 AM
To: Majolee InfoTech; Wim Paulussen
Cc: pgsql-php@postgresql.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@postgresql.org > [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Chris Boget > Sent: Tuesday, March 02, 2004 1:29 AM > To: Majolee InfoTech; Wim Paulussen > Cc: pgsql-php@postgresql.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@postgresql.org) >