The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

XAS::Apps::Database::ExtractData - This module will extract data from a PostgreSQL dump file

SYNOPSIS

use XAS::Apps::Database::ExtractData;

my $app = XAS::Apps::Database::ExtractData->new(;
   -throws  => 'xas-pg-extract-data',
);

exit $app->run();

DESCRIPTION

This module will extract the "copy" statements from a PostgreSQL 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.

OPTIONS

The following options are used to configure the module.

--file

Defines the dump file to use.

--table

Defines which table to extract data from.

--schema

Defines the database schema to use.

SEE ALSO

XAS::Model
XAS

AUTHOR

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

COPYRIGHT AND LICENSE

Copyright (c) 2012-2015 by Kevin L. Esteb

This is free software; you can redistribute it and/or modify it under the terms of the Artistic License 2.0. For details, see the full text of the license at http://www.perlfoundation.org/artistic_license_2_0.