Message-Id: <s187637a.027@cbc.ca>
Date: Tue, 02 Nov 2004 10:03:40 -0500
From: "Arash Zaryoun" <Arash_Zaryoun@CBC.CA>
To: <lorid@dri.edu>, <achill@matrix.gatewaynet.com>
Cc: <erik.wasser@iquer.net>, <pgsql-sql@postgresql.org>
Subject: Re: 'show databases' in psql way?
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

in command line: psql template1 pgsql -l

in PSQL:
foodb=3D#> select datname from pg_database;

- Arash

>>> Achilleus Mantzios <achill@matrix.gatewaynet.com> 11/2/2004 10:21:06 =
AM >>>
O lorid ****** **** Nov 2, 2004 :

> \z   will list the tables in the dbase
> \d tablename will list the columns in the table
>=20

or=20
foodb=3D# SELECT oid,* from pg_database ;

> ---------------------
> Erik Wasser wrote:
>=20
> >Hi list,
> >
> >how can I list the databases in a postgresish way? I know about the =
'-l'=20
> >switch of 'psql' but is there a DBI/SQL-query way? I don't want to =
call=20
> >an external program only to list the databases. I've googled about =
this=20
> >problem but I only found the '-l'-way to this this.
> >
> >Ideas? Solutions?
> >
> > =20
> >
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
>                http://www.postgresql.org/docs/faqs/FAQ.html=20
>=20

--=20
-Achilleus


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html