Re: postgre Databases

From: "Haydar Haydar" <yxselamxy(at)web(dot)de>
To: "DevrimGUNDUZ" <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgre Databases
Date: 2003-07-01 10:07:13
Message-ID: 200307011007.h61A7DQ15814@mailgate5.cinetic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!
Thanks for your help.
Is there also a way to get the database schema with all tables and attributes?
Devrim GUNDUZ <devrim(at)gunduz(dot)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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)tr
> http://www.tdmsoft.com
> http://www.gunduz.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

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

Browse pgsql-admin by date

  From Date Subject
Next Message Gémes Géza 2003-07-01 11:23:07 Re: postgreSQL users = LDAP users?
Previous Message Devrim GUNDUZ 2003-07-01 07:57:01 Re: postgre Databases