Re: Getting a Database List - Mailing list pgsql-general

From frbn
Subject Re: Getting a Database List
Date
Msg-id 3D410FB7.3000609@efbs-seafrigo.fr
Whole thread Raw
In response to Getting a Database List  ("Lee" <lee@dev.null.com>)
List pgsql-general
Lee a écrit:
> 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


shell$ psql -E databasename
user$ \l




pgsql-general by date:

Previous
From: stefan@extum.com
Date:
Subject: Re: PG monitoring tool in Tcl/Tk
Next
From: "Ahmad Munif"
Date:
Subject: how to get primary / unique key on table ?