Perl/Pg.pm/DBI.pm question - Mailing list pgsql-interfaces

From Ludovic Marcotte
Subject Perl/Pg.pm/DBI.pm question
Date
Msg-id Pine.LNX.3.96.981014231312.13897A-100000@extra.Sophos.ca
Whole thread Raw
List pgsql-interfaces
Hi,
    First of all, I'd like to know how can I connect to a non-local
database using the DBI->connect function with the Pg.pm module. Presently,
I use a call like the following:

$dbh = DBI->connect("dbi:Pg:dbname=$dbmain", $dbuser, $dbpass, {PrintError
=> 0}) or die $DBI::errstr;

where all my variables are defined correctly and this works ok for my
local database connection.. but suppose I'd like to connect to the host
foo.bar.com, port 5432, dbname=test .. what syntax should I use to do so?

     Finally, I'd like to know if Pg.pm does support crypt
authentication? If yes, how can I use it?

Thanks a lot in advance,
            Ludovic


pgsql-interfaces by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [INTERFACES] applet
Next
From: Andrea Antibo
Date:
Subject: Re: [INTERFACES] applet