DBIx::PgLink::Local DBI emulation for local data access in PostgreSQL PL/Perl function
Download

DBIx::PgLink::Local Ranking & Summary

DBIx::PgLink::Local Tags

perl PostgreSQL DBI Perl function DBI emulation local data access

DBIx::PgLink::Local Description

DBI emulation for local data access in PostgreSQL PL/Perl function DBIx::PgLink::Local is a DBI emulation for local data access in PostgreSQL PL/Perl function.SYNOPSISPostgreSQL script CREATE FUNCTION fn() RETURNS ... LANGUAGE plperlu AS $$ ... use DBIx::PgLink::Local; $q = pg_dbh->prepare( q ); $q->execute("world"); while (my $row = $q->fetchrow_hashref) { elog 'INFO', $row->{foo}; # prints 'Hello, world' } ... $v = pg_dbh->selectrow_array( 'SELECT $1 * $1 as bar', # query string { types=> } ), # attributes 3 # parameter values ); elog 'INFO', $v; # prints '9' ... $$WARNING: this module works only in PostgreSQL functions written in PL/PerlU language in PostgreSQL server version 8.2 or higher.DBIx::PgLink::Local is a wrapper around PL/Perl Server Programming Interface (SPI) functions. Module provides only basic functions of DBI. For full DBI-compatible driver look at DBD::PgSPI.Module manage prepared statements and cache query plans. It is not depend on other DBIx::PgLink code (except DBIx::PgLink::Logger) and can be used in any PL/Perl function. Requirements: · Perl

DBIx::PgLink::Local Related Software