Re: Suitable Driver ?

On Thu, 11 Oct 2001, Balaji Venkatesan wrote:

>         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.
You need DBD::Pg, which is a DBD driver for postgres.

> 
>         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.
You need use DBI; and use DBD::Pg;
Pg by itself is slightly lower-level module that is similar to C interface
to postgresql.

>         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 ...
To location of your installed postgres includes' and libraries
For example:

export POSTGRES_INCLUDE=/usr/local/pgsql/include
export POSTGRES_LIB=/usr/local/pgsql/lib

-alex