NAME
DBIx::SQLEngine::Driver::Pg - Support DBD::Pg
SYNOPSIS
DBI Wrapper: Adds methods to a DBI database handle.
my$sqldb= DBIx::SQLEngine->new('dbi:pg:test');
Portability Subclasses: Uses driver's idioms or emulation.
$hash_ary=$sqldb->fetch_select(table=>'students'limit=> 5,offset=> 10);
DESCRIPTION
This package provides a subclass of DBIx::SQLEngine which compensates for Postgres's idiosyncrasies.
About Driver Subclasses
You do not need to use this package directly; when you connect to a database, the SQLEngine object is automatically re-blessed in to the appropriate subclass.
sql_limit
$sqldb->sql_limit($limit,$offset,$sql,@params) :$sql,@params
Adds support for SQL select limit clause.
do_insert_with_sequence
$sqldb->do_insert_with_sequence($sequence_name,%sql_clauses) :$row_count
Implemented using _seq_do_insert_preinc and seq_increment.
seq_increment
$sqldb->seq_increment($table,$field) :$new_value
Increments the sequence, and returns the newly allocated value.
dbms_create_column_types
$sqldb->dbms_create_column_types () :%column_type_codes
Implemented using Pg's bytea and serial types.
dbms_create_column_text_long_type
$sqldb->dbms_create_column_text_long_type () :$col_type_str
Implemented using Pg's text type.
recoverable_query_exceptions
$sqldb->recoverable_query_exceptions() :@common_error_messages
Provides a list of error messages which represent common communication failures or other incidental errors.
SEE ALSO
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.