CGI::Session::Driver::postgresql man page on Pidora

Man page or keyword search:  
man Server   31170 pages
apropos Keyword Search (all sections)
Output format
Pidora logo
[printable version]

CGI::Session::Driver::UsergContributed PerlCGI::Session::Driver::postgresql(3)

NAME
       CGI::Session::Driver::postgresql - PostgreSQL driver for CGI::Session

SYNOPSIS
	   use CGI::Session;
	   $session = new CGI::Session("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 = new CGI::Session("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 "\0" in Perl,
       not to be confused with SQL NULL). If you know there is no chance of
       ever having a null character in the serialized data, you can leave off
       the ColumnType attribute. Using a BYTEA column type and "ColumnType =>
       'binary'" is recommended when using Storable as the serializer or if
       there's any possibility that a null value will appear in any of the
       serialized data.

       To use different column names, change the 'create table' statement, and
       then simply do this:

	   $s = new CGI::Session('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       DataSource=>'dbi:pg:dbname=project',
	   });

       or

	   $s = new CGI::Session('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       Handle=>$dbh,
	   });

       For more details see CGI::Session::Driver::DBI, parent class.

       Also see sqlite driver, which exercises different method for dealing
       with binary data.

COPYRIGHT
       Copyright (C) 2002 Cosimo Streppone. All rights reserved. This library
       is free software and can be modified and distributed under the same
       terms as Perl itself.

AUTHORS
       Cosimo Streppone <cosimo@cpan.org>, heavily based on the
       CGI::Session::MySQL driver by Sherzod Ruzmetov, original author of
       CGI::Session.

       Matt LeBlanc contributed significant updates for the 4.0 release.

LICENSING
       For additional support and licensing see CGI::Session

perl v5.14.2			  2008-07-1CGI::Session::Driver::postgresql(3)
[top]

List of man pages available for Pidora

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net