Re: Getting a Database List

On Thu, Jul 25, 2002 at 10:55:04AM +0800, Lee wrote:
> I need to know the interactive SQL syntax to get a listing of databases on
> the current server.

psql -l

select * from pg_database; (IIRC)

> Using Informix, the commands would be:
> database sysmaster;
> select name from sysdatabases;
>
> MySQL:
> show databases;
>
> MS-SQL:
> SELECT name FROM master..sysdatabases ORDER BY name
>
> Please reply by posting to this newsgroup. My email address is hashed to
> protect me from spamming.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.