Обсуждение: postgre Databases

Hi!
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.
____________________________________________________________________________
Nur bei WEB.DE Testsieger FreeMail testen und damit 1 qm Regenwald
schuetzen. Jetzt anmelden und mithelfen! http://user.web.de/Regenwald

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

Hi!
Thanks for your help.
Is there also a way to get the database schema with all tables and attributes?
Devrim GUNDUZ <devrim@gunduz.org> schrieb am 01.07.03 09:57:22:
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


______________________________________________________________________________
UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an
UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 01 July 2003 00:57, Devrim GUNDUZ wrote:
> 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:
>

$ psql -l

will do the trick as well.

- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/Aad9WgwF3QvpWNwRAoiRAJ40C3eW/f3cM3fKGHMiQI6w5Ge3cQCgmSpI
VH1WxTxLs4U4mb8XucVpQBE=
=kdgS
-----END PGP SIGNATURE-----