Re: Getting a Database List

From: Tom Jenkins <tjenkins(at)devis(dot)com>
To: Lee <lee(at)dev(dot)null(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting a Database List
Date: 2002-07-25 17:39:19
Message-ID: 3D4037C7.7000104@devis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

select * from pg_database;

while in psql you can do \dS (i believe) to get a list of system tables
and views.

Tom Jenkins

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-25 18:01:05 Re: Error while dropping a table
Previous Message Johnson, Shaunn 2002-07-25 17:32:17 Migrating database (7.1.3 - 7.2.1)