CGI::Session::Driver::postgresql(3pm) User Contributed Perl Documentation CGI::Session::Driver::postgresql(3pm)
NAME
CGI::Session::Driver::postgresql - PostgreSQL driver for CGI::Session
SYNOPSIS
use CGI::Session;
$session = CGI::Session->new("driver:PostgreSQL", undef, {Handle=>$dbh});
DESCRIPTION
CGI::Session::PostgreSQL is a CGI::Session driver to store session data in a PostgreSQL table.
STORAGE
Before you can use any DBI-based session drivers you need to make sure compatible database table is created for CGI::Session to work with.
Following command will produce minimal requirements in most SQL databases:
CREATE TABLE sessions (
id CHAR(32) NOT NULL PRIMARY KEY,
a_session BYTEA NOT NULL
);
and within your code use:
use CGI::Session;
$session = CGI::Session->new("driver:PostgreSQL", undef, {Handle=>$dbh, ColumnType=>"binary"});
Please note the ColumnType argument. PostgreSQL's text type has problems when trying to hold a null character. (Known as "