PAB3::DB::Driver::Postgres PAB3::DB::Driver::Postgres is a Perl5 wrapper to the pgsql libary and driver for the PAB3::DB class.
Download

PAB3::DB::Driver::Postgres Ranking & Summary

PAB3::DB::Driver::Postgres Tags

Perl module pgsql libary pgsql libary

PAB3::DB::Driver::Postgres Description

PAB3::DB::Driver::Postgres is a Perl5 wrapper to the pgsql libary and driver for the PAB3::DB class. PAB3::DB::Driver::Postgres is a Perl5 wrapper to the pgsql libary and driver for the PAB3::DB class.SYNOPSIS use PAB3::DB::Driver::Postgres; # functions and constants are exported by default $linkid = pg_connect(); $linkid = pg_connect( $server ); $linkid = pg_connect( $server, $user ); $linkid = pg_connect( $server, $user, $auth ); $linkid = pg_connect( $server, $user, $auth, $db ); $linkid = pg_connect( $server, $user, $auth, $db, $client_flag ); $resid = pg_query( $statement ); $resid = pg_query( $linkid, $statement ); $stmtid = pg_prepare( $statement ); $stmtid = pg_prepare( $linkid, $statement ); $rv = pg_bind_param( $stmtid, $p_num ); $rv = pg_bind_param( $stmtid, $p_num, $value ); $rv = pg_bind_param( $stmtid, $p_num, $value, $type ); $stmtid = $resid = pg_execute( $stmtid ); $stmtid = $resid = pg_execute( $stmtid, @bind_values ); @row = pg_fetch_row( $resid ); @row = pg_fetch_row( $stmtid ); @row = pg_fetch_array( $resid ); @row = pg_fetch_array( $stmtid ); @col = pg_fetch_col( $resid ); @col = pg_fetch_col( $stmtid ); %row = pg_fetch_hash( $resid ); %row = pg_fetch_hash( $stmtid ); @names = pg_fetch_names( $resid ); @names = pg_fetch_names( $stmtid ); @lengths = pg_fetch_lengths( $resid ); @lengths = pg_fetch_lengths( $stmtid ); $num_rows = pg_num_rows( $resid ); $num_rows = pg_num_rows( $stmtid ); $row_index = pg_row_tell( $resid ); $row_index = pg_row_tell( $stmtid ); pg_row_seek( $resid, $row_index ); pg_row_seek( $stmtid, $row_index ); $num_fields = pg_num_fields( $resid ); $num_fields = pg_num_fields( $stmtid ); %field = pg_fetch_field( $resid ); %field = pg_fetch_field( $resid, $offset ); %field = pg_fetch_field( $stmtid ); %field = pg_fetch_field( $stmtid, $offset ); $field_index = pg_field_tell( $resid ); $field_index = pg_field_tell( $stmtid ); $hr = pg_field_seek( $resid ); $hr = pg_field_seek( $resid, $offset ); $hr = pg_field_seek( $stmtid ); $hr = pg_field_seek( $stmtid, $offset ); pg_free_result( $resid ); pg_free_result( $stmtid ); $affected_rows = pg_affected_rows(); $affected_rows = pg_affected_rows( $linkid ); $affected_rows = pg_affected_rows( $stmtid ); $id = pg_insert_id( $field, $table ); $id = pg_insert_id( $field, $table, $schema ); $id = pg_insert_id( $linkid, $field, $table ); $id = pg_insert_id( $linkid, $field, $table, $schema ); $id = pg_insert_id( $stmtid, $field, $table ); $id = pg_insert_id( $stmtid, $field, $table, $schema ); $hr = pg_set_charset( $charset ); $hr = pg_set_charset( $linkid, $charset ); $charset = pg_get_charset(); $charset = pg_get_charset( $linkid ); $quoted = pg_quote( $str ); $quoted = pg_quote_id( ... ); pg_auto_commit( $mode ); pg_auto_commit( $linkid, $mode ); pg_begin_work(); pg_begin_work( $linkid ); pg_commit(); pg_commit( $linkid ); pg_rollback(); pg_rollback( $linkid ); $str = pg_error(); $str = pg_error( $linkid ); pg_close(); pg_close( $linkid ); pg_close( $stmtid ); pg_close( $resid );PAB3::DB::Driver::Postgres provides an interface to the pgsql library.This module should be threadsafe, BUT:If you plan using threads, you should use own connections in each thread. It is never safe to use the same connection in two or more threads.Under ModPerl or PerlEx environment several scripts may take access to the same instance of the perl interpreter. All functions are thread local but global to the interpreter! If you plan using different connections in your scripts which may access to the same interpreter you should explicitly set $linkid in all expected functions. You can alternatively use the PAB3::DB class. It takes care of it by itself. Requirements: · Perl

PAB3::DB::Driver::Postgres Related Software