Connect to postgresql database using Perl

Hello

2010/3/31 dipti shah <shahdipti1980@gmail.com>:

Hi,

Could anyone please provide me an example to connect to a postgresql
database using Perl language and accessing the tables, schemas, and other
postgresql objects.

http://www.felixgers.de/teaching/perl/perl_DBI.html
http://structbio.vanderbilt.edu/chazin/wisdom/dbi_howto.html

Regards

Pavel Stehule

Thanks Guys. DBI works fine. I have written below code but it executes only
on the server where I installed postgresql. Is there any way to run this
code from remote host. I get an error when trying to run it from remote
host. I think it is obvious because in below code there is no information
where to connect to. Could you please help me out.

use DBI;
$DB_name = 'mydb';
$DB_user = 'postgres';
$DB_pwd = '';
$dbh = DBI->connect("dbi:Pg:dbname=$DB_name","$DB_user","$DB_pwd");
if ( !defined $dbh ) { die "Cannot connect to database!\n"; }
$sth = $dbh->prepare("SELECT * FROM mytable");
$sth->execute();
while ( ($id,$name) = $sth->fetchrow_array() ) { print "$id\t\t $name \n";
}
$sth->finish();
$dbh->disconnect();

*remote-host# perl pg-connect.pl
DBI connect('dbname=sysdb','postgres',...) failed: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at
pg-connect.pl line 7
Cannot connect to database!
*
Thanks,
Dipti

On Wed, Mar 31, 2010 at 11:53 AM, Pavel Stehule <pavel.stehule@gmail.com>wrote:

dipti shah wrote:

Thanks Guys. DBI works fine. I have written below code but it executes
only on the server where I installed postgresql. Is there any way to
run this code from remote host. I get an error when trying to run it
from remote host. I think it is obvious because in below code there is
no information where to connect to. Could you please help me out.

use DBI;
$DB_name = 'mydb';
$DB_user = 'postgres';
$DB_pwd = '';
$dbh = DBI->connect("dbi:Pg:dbname=$DB_name","$DB_user","$DB_pwd");
...

see http://search.cpan.org/~turnstep/DBD-Pg-2.16.1/Pg.pm#connect
<http://search.cpan.org/%7Eturnstep/DBD-Pg-2.16.1/Pg.pm#connect&gt;

add ;host=hostname-or-ip to the connect string...

That was cool ! Thanks a ton. Got my things done.

On Wed, Mar 31, 2010 at 1:13 PM, John R Pierce <pierce@hogranch.com> wrote:

On Wed, Mar 31, 2010 at 3:25 AM, dipti shah <shahdipti1980@gmail.com> wrote:

Thanks Guys. DBI works fine. I have written below code but it executes only
on the server where I installed postgresql. Is there any way to run this
code from remote host. I get an error when trying to run it from remote
host. I think it is obvious because in below code there is no information
where to connect to. Could you please help me out.

Hi, Dipti.

Have a look at the DBI documentation. As you suspect, you will need
to specify the host.

Sean