.\" Automatically generated by Pod::Man 2.28 (Pod::Simple 3.29)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is turned on, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{
.    if \nF \{
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
.    \" fudge factors for nroff and troff
.if n \{\
.    ds #H 0
.    ds #V .8m
.    ds #F .3m
.    ds #[ \f1
.    ds #] \fP
.\}
.if t \{\
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
.    ds #V .6m
.    ds #F 0
.    ds #[ \&
.    ds #] \&
.\}
.    \" simple accents for nroff and troff
.if n \{\
.    ds ' \&
.    ds ` \&
.    ds ^ \&
.    ds , \&
.    ds ~ ~
.    ds /
.\}
.if t \{\
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
.    \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
.    \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
.    \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
.    ds : e
.    ds 8 ss
.    ds o a
.    ds d- d\h'-1'\(ga
.    ds D- D\h'-1'\(hy
.    ds th \o'bp'
.    ds Th \o'LP'
.    ds ae ae
.    ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "CGI::Session::Driver::postgresql 3pm"
.TH CGI::Session::Driver::postgresql 3pm "2016-01-15" "perl v5.22.1" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
CGI::Session::Driver::postgresql \- PostgreSQL driver for CGI::Session
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 2
\&    use CGI::Session;
\&    $session = CGI::Session\->new("driver:PostgreSQL", undef, {Handle=>$dbh});
.Ve
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
CGI::Session::PostgreSQL is a CGI::Session driver to store session data in a PostgreSQL table.
.SH "STORAGE"
.IX Header "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 \s-1SQL\s0 databases:
.PP
.Vb 4
\&    CREATE TABLE sessions (
\&        id CHAR(32) NOT NULL PRIMARY KEY,
\&        a_session BYTEA NOT NULL
\&    );
.Ve
.PP
and within your code use:
.PP
.Vb 2
\&    use CGI::Session;
\&    $session = CGI::Session\->new("driver:PostgreSQL", undef, {Handle=>$dbh, ColumnType=>"binary"});
.Ve
.PP
Please note the \fIColumnType\fR argument. PostgreSQL's text type has problems when trying to hold a null character. (Known as \f(CW"\e0"\fR in Perl, not to be confused with \s-1SQL \s0\fI\s-1NULL\s0\fR). If you know there is no chance of ever having a null character in the serialized data, you can leave off the \fIColumnType\fR attribute. Using a \fI\s-1BYTEA\s0\fR column type and \f(CW\*(C`ColumnType => \*(Aqbinary\*(Aq\*(C'\fR 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.
.PP
To use different column names, change the 'create table' statement, and then simply do this:
.PP
.Vb 7
\&    $s = CGI::Session\->new(\*(Aqdriver:pg\*(Aq, undef,
\&    {
\&        TableName=>\*(Aqsession\*(Aq,
\&        IdColName=>\*(Aqmy_id\*(Aq,
\&        DataColName=>\*(Aqmy_data\*(Aq,
\&        DataSource=>\*(Aqdbi:pg:dbname=project\*(Aq,
\&    });
.Ve
.PP
or
.PP
.Vb 7
\&    $s = CGI::Session\->new(\*(Aqdriver:pg\*(Aq, undef,
\&    {
\&        TableName=>\*(Aqsession\*(Aq,
\&        IdColName=>\*(Aqmy_id\*(Aq,
\&        DataColName=>\*(Aqmy_data\*(Aq,
\&        Handle=>$dbh,
\&    });
.Ve
.PP
For more details see CGI::Session::Driver::DBI, parent class.
.PP
Also see sqlite driver, which exercises different method for dealing with binary data.
.SH "COPYRIGHT"
.IX Header "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.
.SH "AUTHORS"
.IX Header "AUTHORS"
Cosimo Streppone <cosimo@cpan.org>, heavily based on the CGI::Session::MySQL driver by Sherzod Ruzmetov, original author of CGI::Session.
.PP
Matt LeBlanc contributed significant updates for the 4.0 release.
.SH "LICENSING"
.IX Header "LICENSING"
For additional support and licensing see CGI::Session