NAME
DBIx::Compare::Pg - Compare PostgreSQL database content
SYNOPSIS
use DBIx::Compare::Pg;
my $oDB_Comparison = db_comparison->new($dbh1,$dbh2);
$oDB_Comparison->verbose;
$oDB_Comparison->compare;
$oDB_Comparison->deep_compare;
$oDB_Comparison->deep_compare(@aTable_Names); DESCRIPTION
DBIx::Compare::Pg takes two PostgreSQL database handles and performs comparisons of their table content. See DBIx::Compare for more information.
PORTING NOTES
deep_compare, deep_compare(@aTables)
Use is made of CURSORs to avoid triggering an OOM condition due to libpq's buffering behaviour when comparing tables larger than physical memory.
get_tables
All non-system schemata are searched. Some (hopefully) sensible decisions are made concerning skipping possible Slony schemata (beginning with "_"). Likewise the information schema is passed over.
SEE ALSO
AUTHOR
Christopher Jones, Gynaecological Cancer Research Laboratories, UCL EGA Institute for Women's Health, University College London.
c.jones@ucl.ac.uk
This particular module has seen some hacking from;
Mark Kirkwood, Catalyst IT Limited, New Zealand.
mark.kirkwood@gmail.com
COPYRIGHT AND LICENSE
Copyright 2008 by Christopher Jones, University College London
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.