| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | Devrim GUNDUZ <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgre Databases |
| Date: | 2003-07-01 15:23:41 |
| Message-ID: | 200307010823.42933.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----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(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/Aad9WgwF3QvpWNwRAoiRAJ40C3eW/f3cM3fKGHMiQI6w5Ge3cQCgmSpI
VH1WxTxLs4U4mb8XucVpQBE=
=kdgS
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | weigelt | 2003-07-01 16:00:51 | Re: replication/redundancy |
| Previous Message | Jonathan Gardner | 2003-07-01 15:22:37 | Re: replication/redundancy |