pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-sql@postgresql.org
Cc: erik.wasser@iquer.net
Subject: Re: 'show databases' in psql way?
Date: Tue,  2 Nov 2004 03:40:53 -0000
Message-ID: <63533a400e3d9e681c7b819780c5cd35@biglumber.com> (raw)
In-Reply-To: <200411011313.10872.erik.wasser@iquer.net>


-----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@turnstep.com
PGP Key: 0x14964AC8 200411012240
 
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFBhwIHvJuQZxSWSsgRArd1AJ9hKXD+cSaM2L3RUXQdabuRofNFjwCfaHT0
+bRPuYhuED0mnlp1FRtvQQw=
=tsqe
-----END PGP SIGNATURE-----

view thread (9+ messages)  latest in thread

Message-ID: <63533a400e3d9e681c7b819780c5cd35@biglumber.com>
Permalink:  ../63533a400e3d9e681c7b819780c5cd35@biglumber.com/
Also on:    postgresql.org/message-id/63533a400e3d9e681c7b819780c5cd35@biglumber.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: greg@turnstep.com, erik.wasser@iquer.net
  Subject: Re: 'show databases' in psql way?
  In-Reply-To: <63533a400e3d9e681c7b819780c5cd35@biglumber.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox