Re: postgre Databases - Mailing list pgsql-admin

From Devrim GUNDUZ
Subject Re: postgre Databases
Date
Msg-id Pine.LNX.4.44.0307011053220.1804-100000@emo.org.tr
Whole thread Raw
In response to postgre Databases  ("Haydar Haydar" <yxselamxy@web.de>)
Responses Re: postgre Databases  (Jonathan Gardner <jgardner@jonathangardner.net>)
List pgsql-admin
Hi,

On Tue, 1 Jul 2003, Haydar Haydar wrote:

> Postgre is running but have I forget my database name and now i can not
> connect to the database.Is it possible to get all database names.

Connect to PostgreSQL with psql

psql template1 -U postgres

Then enter \l command:

proftpd=# \l
           List of databases
      Name       |  Owner   | Encoding
-----------------+----------+-----------
 ankara2003      | postgres | SQL_ASCII
....

\l will list all databases.

Regards,
--
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr
            http://www.tdmsoft.com
            http://www.gunduz.org


pgsql-admin by date:

Previous
From: "Haydar Haydar"
Date:
Subject: postgre Databases
Next
From: "Haydar Haydar"
Date:
Subject: Re: postgre Databases