1 package DBIx::Class::Loader::Pg;
4 use base 'DBIx::Class::Loader::Generic';
8 our $SCHEMA = 'public';
12 DBIx::Class::Loader::Pg - DBIx::Class::Loader Postgres Implementation.
16 use DBIx::Class::Loader;
18 # $loader is a DBIx::Class::Loader::Pg
19 my $loader = DBIx::Class::Loader->new(
20 dsn => "dbi:Pg:dbname=dbname",
25 my $class = $loader->find_class('film'); # $class => Data::Film
26 my $obj = $class->retrieve(1);
30 See L<DBIx::Class::Loader>.
35 return qw/DBIx::Class::PK::Auto::Pg/;
40 my $dbh = DBI->connect( @{ $self->{_datasource} } ) or croak($DBI::errstr);
42 # This is split out to avoid version parsing errors...
43 my $is_dbd_pg_gte_131 = ( $DBD::Pg::VERSION >= 1.31 );
44 my @tables = $is_dbd_pg_gte_131 ?
45 $dbh->tables( undef, $SCHEMA, "", "table", { noprefix => 1, pg_noprefix => 1 } )
54 my ( $self, $table ) = @_;
55 my $dbh = DBI->connect( @{ $self->{_datasource} } ) or croak($DBI::errstr);
57 my $sth = $dbh->column_info(undef, $SCHEMA, $table, undef);
58 my @cols = map { $_->[3] } @{ $sth->fetchall_arrayref };
61 my @primary = $dbh->primary_key(undef, $SCHEMA, $table);
67 return ( \@cols, \@primary );
72 L<DBIx::Class::Loader>