Your best shot should be DBD::pg for normal use. It is a module dependant on the DBI and it would allow you to apply some general knowledge to your specific problem. Meaning that, once you learn how to use Postgres from the DBI, you can also use whichever other database without much effort.

An alternative, useful in cases when you can't install the Postrgres client, is DBD:PgPP. From its docs:
DBD::PgPP is a Pure Perl client interface for the PostgreSQL database. This module implements network protocol between server and client of PostgreSQL, thus you don't need external PostgreSQL client library like libpq for this module to work. It means this module enables you to connect to PostgreSQL server from some operation systems which PostgreSQL is not ported.

Finally, there is DBD::ODBC, which will access your database through the ODBC interface. Be aware that, while this is a generalized approach that will smooth the differences between databases, it will aslo pre-process your queries, adding some overhead that in several cases can account to up to 20-30% of your performance.

Pg and PgSQL haven't been updated for years, and I would not start with them.

 _  _ _  _  
(_|| | |(_|><
 _|

[download]

In reply to Re: Recommendations on module for Perl <-> PostgreSQL interaction by gmax
in thread Recommendations on module for Perl <-> PostgreSQL interaction by dargosch

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.