- PORTING NOTES
- SEE ALSO
- COPYRIGHT AND LICENSE
DBIx::Compare::Pg - Compare PostgreSQL database content
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);
DBIx::Compare::Pg takes two PostgreSQL database handles and performs comparisons of their table content. See DBIx::Compare for more information.
Use is made of CURSORs to avoid triggering an OOM condition due to libpq's buffering behaviour when comparing tables larger than physical memory.
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.
Christopher Jones, Gynaecological Cancer Research Laboratories, UCL EGA Institute for Women's Health, University College London.
This particular module has seen some hacking from;
Mark Kirkwood, Catalyst IT Limited, New Zealand.
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.