GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  CLASS::DBI::PG (3)

.ds Aq ’

NAME

Class::DBI::Pg - Class::DBI extension for Postgres

CONTENTS

SYNOPSIS



  use strict;
  use base qw(Class::DBI::Pg);

  __PACKAGE__->set_db(Main => dbi:Pg:dbname=dbname, user, password);
  __PACKAGE__->set_up_table(film);



DESCRIPTION

Class::DBI::Pg automate the setup of Class::DBI columns and primary key for Postgres.

select Postgres system catalog and find out all columns, primary key and SERIAL type column.

create table.



 CREATE TABLE cd (
     id SERIAL NOT NULL PRIMARY KEY,
     title TEXT,
     artist TEXT,
     release_date DATE
 );



setup your class.



 package CD;
 use strict;
 use base qw(Class::DBI::Pg);

 __PACKAGE__->set_db(Main => dbi:Pg:dbname=db, user, password);
 __PACKAGE__->set_up_table(cd);



This is almost the same as the following way.



 package CD;

 use strict;
 use base qw(Class::DBI);

 __PACKAGE__->set_db(Main => dbi:Pg:dbname=db, user, password);
 __PACKAGE__->table(cd);
 __PACKAGE__->columns(Primary => id);
 __PACKAGE__->columns(All => qw(id title artist release_date));
 __PACKAGE__->sequence(cd_id_seq);



METHODS

    set_up_table TABLENAME HASHREF

Declares the Class::DBI class specified by TABLENAME. HASHREF can specify options to when setting up the table.
ColumnGroup You can specify the column group that you want your columns to be in.



   $class->set_up_table($table,  { ColumnGroup => Essential });



The default is ’All’

Primary Overrides primary key setting. This can be useful when working with views instead of tables.

    pg_version

Returns the postgres version that you are currently using.

AUTHOR

Daisuke Maki dmaki@cpan.org

AUTHOR EMERITUS

Sebastian Riedel, sri@oook.de IKEBE Tomohiro, ikebe@edge.co.jp

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

Class::DBI Class::DBI::mysql DBD::Pg
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 CLASS::DBI::PG (3) 2016-04-03

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.