Re: Listing databases

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