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

Поиск
Список
Период
Сортировка
Искать

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

От:
monika.koenig@bonn.de (M.König)
Дата:
Jack Flak  wrote in message news:<9MEG9.2902$PK6.160071979@newssvr14.news.prodigy.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 ;

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

От:
Jack Flak <jack@flak.net>
Дата:
Thanks for the help!  That worked just fine.

I also found this (from within psql):

# \l
  List of databases
 Database  |  Owner
-----------+----------
 template0 | postgres
 template1 | postgres
 testdb    | postgres
(3 rows)

And this from command-line:

$ /usr/local/pgsql/bin/psql -l
Password:
  List of databases
 Database  |  Owner
-----------+----------
 template0 | postgres
 template1 | postgres
 testdb    | postgres
(3 rows)

Thanks again! 


M.König wrote:

> Jack Flak  wrote in message
> news:<9MEG9.2902$PK6.160071979@newssvr14.news.prodigy.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 ;
> 

FAQ