Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Jenkins
Subject Re: Getting a Database List
Date
Msg-id 3D4037C7.7000104@devis.com
Whole thread Raw
In response to Getting a Database List  ("Lee" <lee@dev.null.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Migrating database (7.1.3 - 7.2.1)
Next
From: Tom Lane
Date:
Subject: Re: Error while dropping a table