Re: postgresql perl connectivity - Mailing list pgsql-general

From jseymour@linxnet.com (Jim Seymour)
Subject Re: postgresql perl connectivity
Date
Msg-id 20040628133503.75DC4430E@jimsun.linxnet.com
Whole thread Raw
In response to Re: postgresql perl connectivity  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> wrote:
>
> On Sun, Jun 27, 2004 at 07:05:13PM -0600, Jay wrote:
>
> > Perhaps the DBD::pg perl module hasn't been fully installed,
> > or perhaps the capitalisation of 'pg' isn't right.
> > Available drivers: ExampleP, Pg, Proxy, Sponge, mysql.
> > at psqldb.pl line 10
>
> So, did you try using the Pg driver rather than pg ?  It seems in this
> case capitalisation matters ...

Indeed it does.  The module is DBD::Pg, *not* DBD::pg.

use DBI:
$dbh = DBI->connect("dbi:Pg:dbname=$dbName", $dbUser, $dbPass, [...]);

Jim

pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: is win1250 supported encoding for PG7.5?
Next
From: Tom Lane
Date:
Subject: Re: Performance problem on RH7.1