Re: Getting a Database List

From: frbn <frbn(at)efbs-seafrigo(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting a Database List
Date: 2002-07-26 09:00:39
Message-ID: 3D410FB7.3000609@efbs-seafrigo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pawe 2002-07-26 09:32:11 Postgresql + Oracle XSU
Previous Message stefan 2002-07-26 07:01:42 Re: regression test