NAME

DBIx::Connection::PostgreSQL::SQL - PostgreSQL catalog sql abstractaction layer.

SYNOPSIS

    use DBIx::Connection::PostgreSQL::SQL;

DESCRIPTION

    Represents sql abstractaction layer

EXPORT

None

METHODS

sequence_value

Returns sql statement that returns next sequence value

reset_sequence

Returns sql statement that restarts sequence.

has_sequence

Returns sql statement that check is sequence exists in database schema

set_session_variables

Sets session variables

It uses the following sql command pattern:

    SET variable TO value;

    DBIx::Connection::PostgreSQL::SQL->set_session_variables($connection, {DateStyle => 'US'});

update_lob

Updates lob. (Large Object) Takes connection object, table name, lob column_name, lob conetent, hash_ref to primary key values. optionally lob size column name.

fetch_lob

Retrieve lobs. Takes connection object, table name, lob column_name, hash_ref to primary key values. optionally lob size column name. By default max lob size is set to 1 GB DBIx::Connection::Oracle::SQL::LOB_MAX_SIZE = (1024 * 1024 * 1024);

_create_lob

Creates lob

_read_lob

Reads lob

_unlnik_lob

Removes lob.

_get_lob_size

Returns lob size.

_get_lob_id

Returns lob oid.

SEE ALSO

DBIx::Connection

COPYRIGHT AND LICENSE

The DBIx::Connection::PostgreSQL::SQL module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

AUTHOR

Adrian Witas, adrian@webapp.strefa.pl