The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

XAS::Apps::Base::ExtractData - This module will extract data from a postgres dump file

SYNOPSIS

 use XAS::Apps::Base::ExtractData;

 my $app = XAS::Apps::Base::ExtractData->new(;
    -throws  => 'pg_extract_data',
    -options => [
        {'file=s'   => ''},
        {'table=s'  => ''},
        {'schema=s' => ''}
    ]
 );

 exit $app->run();

DESCRIPTION

This module will extract the "copy" statements from a postgres pg_dumpall file. This is based on the table name. This data is then suitable to populate an "empty" database that already has a schema defined. This allows you to do selective restores.

CONFIGURATION

The following parameters are used to configure the module.

-options

Defines the command line options for this module.

'files=s'

Defines the dump file to use.

'table=s'

Defines which table to extract data from.

'schema=s'

Defines the database schema to use.

SEE ALSO

 bin/pg_extract_data.pl

XAS

AUTHOR

Kevin L. Esteb, <kevin@kesteb.us>

COPYRIGHT AND LICENSE

Copyright (C) 2012 by Kevin L. Esteb

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.