Konstantin Stepanov > FusqlFS > FusqlFS::Backend::PgSQL::Views

Download:
FusqlFS-0.009.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

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.

syntax highlighting: