Re: postgre Databases - Mailing list pgsql-admin

From Jonathan Gardner
Subject Re: postgre Databases
Date
Msg-id 200307010823.42933.jgardner@jonathangardner.net
Whole thread Raw
In response to Re: postgre Databases  (Devrim GUNDUZ <devrim@gunduz.org>)
List 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@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-----

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: big tables with lots-o-rows
Next
From: "Daniel Seichter"
Date:
Subject: Advantages and disadvantages of more than one dbserver on one server