Re: Get a list of databases?

From: joseph speigle <joesp(at)sirfsup(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Get a list of databases?
Date: 2007-02-27 06:12:55
Message-ID: 20070227061255.GA8720@www.sirfsup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>
> My code needs to be able to allow the user to select which
> database to connect to.
>
> Is there a programmatic way to get a list of the databases
> managed by a pgsql server?
you mean like 'psql >\l' ?
try
select datname from pg_database;
--
joe speigle
www.sirfsup.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Hunter 2007-02-27 14:53:54 Re: Get a list of databases?
Previous Message A. Kretschmer 2007-02-27 06:10:43 Re: Get a list of databases?