Re: Database Connect - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: Database Connect
Date
Msg-id Pine.LNX.4.30.0104201344570.5804-100000@chapelperilous.net
Whole thread Raw
In response to Re: Database Connect  (webb sprague <wsprague@o1.com>)
List pgsql-general
On Fri, 20 Apr 2001, webb sprague wrote:

> Aahh!  I have a million Perl scripts that rely on this syntax in the DBI
> to connect to remote databases.
>
> like:
>
> $dbh=DBI->connect( "dbi:Pg:dbname=datab@remotehost",'wsprague','pass',
>              {RaiseError => 1, AutoCommit => 1})
>              or print STDERR "$DBI::errstr<p>";
>
> Umm, do you have any idea what we should do now?

perl -pie 's|@remotehost|;host=remotehost|g' <file>

Or something to that effect :-)

-- Brett
                   http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
Women in love consist of a little sighing, a little crying, a little dying
-- and a good deal of lying.
        -- Ansey




pgsql-general by date:

Previous
From: "Gyozo Papp"
Date:
Subject: recursive select
Next
From: "Vilson farias"
Date:
Subject: Re: very slow execution of stored procedures