Re: dumb question: how to get a list of databases?

From: monika(dot)koenig(at)bonn(dot)de (=?ISO-8859-2?Q?M(dot)K=F6nig?=)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: dumb question: how to get a list of databases?
Date: 2002-12-03 11:34:45
Message-ID: cba90948.0212030334.5f813266@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jack Flak <jack(at)jackflak(dot)net> wrote in message news:<9MEG9(dot)2902$PK6(dot)160071979(at)newssvr14(dot)news(dot)prodigy(dot)com>...
> Greetings group,
>
> How do I get a list of current, existing databases (catalogs) for my
> current installation?
>
> Also: how do I find out my current version in linux? I ran this:
>
> /usr/local/pgsql/bin/psql --version
>
> and I got this:
>
> psql (PostgreSQL) 7.1
>
> So it looks like I'm currently running 7.1. Is this the only way to
> find out?
>
> Thanks for your time.
>
>
> (Email address is invalid to prevent more spam)
you can use a simple sql to find it out.

try: select datname from pg_database ;

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devinder K Rajput 2002-12-03 23:14:36 Command for restart in the contrib/linux script
Previous Message SZUCS Gábor 2002-12-03 10:39:33 Re: Problem of Null Ordering