Re: Perl DBI connection to Postgres

On Tue, Feb 22, 2005 at 13:39:47 +0000,
SG Edwards <s0460205(at)sms(dot)ed(dot)ac(dot)uk> wrote:
> I'm tyring to use the Perl::DBI module to connect to a postgreSQL database but
> it doesn't seem to like it?
>
> What is the connection statement?! Have used:
>
> use DBI;
> $dbh=DBI->connect('DBI:Pg:user_name', 'user_name', 'password')

Perhaps you want:
$dbh=DBI->connect('DBI:Pg:dbname=user_name', 'user_name', 'password')

>
> but this returns a message that the connection failed due to a missing "=" after
> the user_name?
>
> Any suggestions?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster