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!
> 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. >