X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DC443A47CF for ; Tue, 2 Nov 2004 03:41:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72586-08 for ; Tue, 2 Nov 2004 03:41:01 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 8F3563A4694 for ; Tue, 2 Nov 2004 03:40:59 +0000 (GMT) Received: (qmail 28405 invoked from network); 2 Nov 2004 03:40:53 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 2 Nov 2004 03:40:53 -0000 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Cc: erik.wasser@iquer.net Cc: erik.wasser@iquer.net Subject: Re: 'show databases' in psql way? X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <200411011313.10872.erik.wasser@iquer.net> Date: Tue, 2 Nov 2004 03:40:53 -0000 X-Mailer: JoyMail 1.48 Message-ID: <63533a400e3d9e681c7b819780c5cd35@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200411/12 X-Sequence-Number: 19331 -----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-----