From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | lorid <lorid(at)dri(dot)edu> |
Cc: | Erik Wasser <erik(dot)wasser(at)iquer(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: 'show databases' in psql way? |
Date: | 2004-11-02 15:21:06 |
Message-ID: | Pine.LNX.4.44.0411021719450.3790-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
O lorid έγραψε στις Nov 2, 2004 :
> \z will list the tables in the dbase
> \d tablename will list the columns in the table
>
or
foodb=# SELECT oid,* from pg_database ;
> ---------------------
> Erik Wasser wrote:
>
> >Hi list,
> >
> >how can I list the databases in a postgresish way? I know about the '-l'
> >switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
> >an external program only to list the databases. I've googled about this
> >problem but I only found the '-l'-way to this this.
> >
> >Ideas? Solutions?
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
-Achilleus
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2004-11-02 15:42:36 | Re: Update instead rules on Views |
Previous Message | Markus Schaber | 2004-11-02 15:20:37 | Re: Update instead rules on Views |