package DbConn; use DBI; use Data::Dumper; sub New { my ($Class)=shift; my $Self = {}; bless($Self, $Class); return $Self; } sub connection { shift @_; my ($DBname, $Host, $User_Name, $Password)=@_; my $dbh = DBI->connect("dbi:Pg:dbname=$DBname;host=$Host","$User_Name","$Password",\%attr ) || die $DBI::errstr; return $dbh; #return the database handle } 1;