Re: 'show databases' in psql way?

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: erik(dot)wasser(at)iquer(dot)net
Subject: Re: 'show databases' in psql way?
Date: 2004-11-02 03:40:53
Message-ID: 63533a400e3d9e681c7b819780c5cd35@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



> 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?

Yes, the DBI way is to use the "data_sources" function. Works
just fine for Postgres:

my @dbs = DBI->data_sources('Pg');

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200411012240

-----BEGIN PGP SIGNATURE-----

iD8DBQFBhwIHvJuQZxSWSsgRArd1AJ9hKXD+cSaM2L3RUXQdabuRofNFjwCfaHT0
+bRPuYhuED0mnlp1FRtvQQw=
=tsqe
-----END PGP SIGNATURE-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2004-11-02 04:22:52 Re: Join Table
Previous Message Mischa Sandberg 2004-11-01 19:55:57 Re: Join Table