Suitable Driver ?

From: "Balaji Venkatesan" <balaji(dot)venkatesan(at)megasoft(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Suitable Driver ?
Date: 2001-10-11 06:18:09
Message-ID: 002801c1521c$7fa29d50$2e07a8c0@wksmmc220
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI
I have to setup PERL to interact with PGSQL.
I have taken the following steps.

1.Installation of perl_5.6.0 under Redhat Linux 7.0
2.Installation of POSTGRESQL under Redhat Linux7.0

Both are working perfectly as seperate modules.

Now I need to interface perl with PGSQL.

I need to what's the best possible soln.

I have installed latest DBI from www.cpan.org

Now i need to install DBD For PGSQL .Is
this the driver i have to work on for pgsql ?.
Or do I have any other option to connect to pgsql
from perl . Indeed i've found out an other way
to use Pg driver provided by PGSQL to interface
perl with pgsql.

I need to exactly know the difference between
use Pg ; and use DBI ; Need to which one is
proceeding towards correct direction under what circumstances.

when I tried to install DBD-Pg-0.93.tar.gz under Linux
i get

Configuring Pg
Remember to actually read the README file !
please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !

I need to know what these varibles POSTGRES_INCLUDE and POSTGRES_LIB
should point to ...

and when i tried to run perl test.pl, the program to test the
installation of the module which
comes with the tar.
I get the error

OS: linux
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC
contains: /usr/l
ib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i3
86-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .)
at (eval 1)
line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: ADO, ExampleP, Multiplex, Proxy.
at test.pl line 51

Any body who can clarify is most welcome....

with regards,
Prassanna...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-10-11 06:39:30 Re: extract(timezone_hour) funny business
Previous Message Tom Lane 2001-10-11 05:37:49 Re: row value constructor bug?