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