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
[EMAIL PROTECTED]                               [EMAIL PROTECTED] 
                        http://www.tdmsoft.com
                        http://www.gunduz.org


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to