Getting a Database List

From: "Lee" <lee(at)dev(dot)null(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting a Database List
Date: 2002-07-25 02:55:04
Message-ID: 3d3f6495@news.starhub.net.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to know the interactive SQL syntax to get a listing of databases on
the current server.

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.

Thanks,
Lee

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Brown-Bayliss 2002-07-25 03:21:31 Rolling my own replication
Previous Message Josh Berkus 2002-07-25 02:27:42 Re: [SQL] Case in-sensitive