Re: Writing code to list Databases ?

From: Joe Conway <mail(at)joeconway(dot)com>
To: pgmoscatt(at)optushome(dot)com(dot)au
Cc: "\"PostgreSQL [INTERFACES] \" List" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Writing code to list Databases ?
Date: 2003-08-24 01:56:50
Message-ID: 3F481B62.1000303@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Peter Moscatt wrote:
> Are there routines that allow me to list databases within PostGres ?
>

From a shell prompt, use `psql -l`. The SQL command is:
select datname from pg_database;

HTH,

Joe

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Meskes 2003-08-24 09:25:13 Re: ECPG Problem (Bug?)
Previous Message Peter Moscatt 2003-08-24 01:55:11 Writing code to list Databases ?