PostgreSQL and DBI/DBD...vs Pg.pm - Mailing list pgsql-hackers

From D. Dante Lorenso
Subject PostgreSQL and DBI/DBD...vs Pg.pm
Date
Msg-id 01bd486f$f914c6a0$3a151ecf@redhat.afai.com
Whole thread Raw
List pgsql-hackers
I'm getting confused between the methods of connectivity with PERL.
Right now I'm accessing several MySQL tables using DBI/DBD. However,
I'd like to convert these programs into PostgreSQL apps.  So, I'm
assuming that since I used DBI (a common database connection format)
that I'd only have to change the connect string to point to the
PostgreSQL source rather than MySQL and all should be good.

So, what is Pg.pm? and how is that connected (if at all) to DBI?
I'm running 6.3 on Redhat 5, and psql seems to work Ok.  I look in the
src/interfaces/perl5/ and All I see are files for Pg...and nothing
mentions DBI.  Then, I search Altavista and come up with this in the
latest from CPAN under DBI:

http://www.perl.com/CPAN-local/modules/by-category/07_Database_Interfaces/DB
D/DBD-Pg-0.68.readme

Ok, so the source for PG.pm is version 1.7.0 or so, and the version of this
DBD-Pg is 0.68.  Do these numbers have ANYTHING to do with each other,
or are they two separate products?  Which one do I need, and if I need
the DBD from CPAN (as I suspect), will it work with 6.3?

Dante

.------------------------------------------.-----------------------.
|  _ dlorenso@afai.com - D. Dante Lorenso  | Network Administrator |
| | |    ___  _ _  ___  __ _  ___  ___     |                       |
| | |__ / o \| '_|/ o_\|  \ |\_ _\/ o \    | Accounting Firms      |
| |____|\___/|_|  \___/|_|\_|\___|\___/    | Associated, inc.      |
| http://www.afai.com/~dlorenso            | http://www.afai.com/  |
'------------------------------------------'-----------------------'


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Speedups
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: WG: [QUESTIONS] Re: [HACKERS] text should be a blob field