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 [EMAIL PROTECTED]) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
