Обсуждение: Connect to postgresql database using Perl
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.
Thanks,
Dipti
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.
Thanks,
Dipti
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
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:
Hello
2010/3/31 dipti shah <shahdipti1980@gmail.com>:http://www.felixgers.de/teaching/perl/perl_DBI.html> 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://structbio.vanderbilt.edu/chazin/wisdom/dbi_howto.html
Regards
Pavel Stehule
> Thanks,
> Dipti
>
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 > 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: >> >> 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, >> > Dipti >> > > >
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, > Dipti >