How to connect to postgresql using perl

Question

use DBI;
my $db_host = 'localhost';
my $db_user = 'postgres';
my $db_pass = '12345';
my $db_name = 'postgres';
my $db = "dbi:pg:dbname=${db_name};host=${db_host}";
$dbh = DBI->connect($db, $db_user, $db_pass,{ RaiseError => 1, AutoCommit => 0 }) || die "Error connecting to the database: $DBI::errstr\n";
my $query = "SELECT * FROM random_table";
$ref = $dbh->selectcol_arrayref($query);
print join("\n", @$ref);

When I execute this file. I get an Error. It Says:

DBD::pg initialisation failed: Can't locate object method "driver" via package "DBD::pg"

Do I need to install some driver to connect to the database..?

For a start you must use strict and use warnings, and declare $dbh and $ref as you use them — Borodin
– Borodin, Commented Apr 11, 2013 at 23:28

hobbs · Accepted Answer · 2013-04-11 21:52:40Z

13

It's dbi:Pg, not dbi:pg. Case matters.

answered Apr 11, 2013 at 21:52

hobbs

245k20 gold badges225 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Borodin Over a year ago

And it's PostgreSQL, not postgresql, which is likely to be the source of the mistake. I guess that's why the better programmers get so heated about the difference between perl and Perl: it makes a difference. And the first thing to do if you get a message like Can't locate object method "driver" via package "DBD::pg" is think did I spell this right?

Collectives™ on Stack Overflow

How to connect to postgresql using perl

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related