Re: Listing databases

If you attach with psql then just use \l

Or this works as well

SELECT datname from pg_database;


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


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.