Konstantin Stepanov

NAME

FusqlFS::Backend::PgSQL::Views - FusqlFS PostgreSQL database views interface

SYNOPSIS

    use FusqlFS::Backend::PgSQL::Views;

    my $views = FusqlFS::Backend::PgSQL::Views->new();
    my $list = $views->list();
    $views->create('aview');
    $views->store('aview', { 'content.sql' => 'SELECT * FROM sometable' });
    my $view = $views->get('aview');

DESCRIPTION

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

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

./content.sql

Plain file with SELECT ... SQL statement used to construct query in it. Can be written to redefine view.

./owner

Symlink to view's owner in ../../roles.