NAME

FusqlFS::Backend::PgSQL::Tables - FusqlFS PostgreSQL database tables interface

SYNOPSIS

use FusqlFS::Backend::PgSQL::Tables;

my $tables = FusqlFS::Backend::PgSQL::Tables->new();
my $list = $tables->list();
$tables->create('sometable');
my $table = $tables->get('sometable');
$tables->drop('sometable');

DESCRIPTION

This is FusqlFS an interface to PostgreSQL database tables. This class is not to be used by itself.

This class provides a view of a set of different table's artifacts like indices, struct (fields description), data rows/records, constraints, triggers etc.

See FusqlFS::Artifact for description of interface methods, FusqlFS::Backend to learn more on backend initialization and FusqlFS::Backend::Base for more info on database backends writing.

EXPOSED STRUCTURE

./indices

Table's indices, see FusqlFS::Backend::PgSQL::Table::Indices for details.

./struct

Table's structure, see FusqlFS::Backend::PgSQL::Table::Struct for details.

./constraints

Table's constraints, see FusqlFS::Backend::PgSQL::Table::Constraints for details.

./triggers

Table's triggers, see FusqlFS::Backend::PgSQL::Table::Triggers for details.

./owner

Symlink to table's owner role in ../../roles.

./acl

Table's ACL with permissions given to different roles. See FusqlFS::Backend::PgSQL::Role::Acl for details.