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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)tr
http://www.tdmsoft.com
http://www.gunduz.org