Re: Listing databases - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Listing databases
Date
Msg-id 4099606A.3000203@commandprompt.com
Whole thread Raw
In response to Listing databases  (Doug Hall <doug_hall@aidt.edu>)
List pgsql-general
Doug Hall wrote:
> Sorry for the newbie question, but how do you get PostgreSQL to list the
> available databases? I know how to log into a certain database, but not
> list all of them. I know this must be possible because the phppgAdmin
> web site demonstrates it with their trial server.
>

select * from pg_database;




> Thanks,
> Doug Hall
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-general by date:

Previous
From: CSN
Date:
Subject: sql standard: \' or ''
Next
From: Mike Nolan
Date:
Subject: Re: Listing databases