Provided by: apgdiff_2.3-1_all
apgdiff - Another PostgreSQL Diff Tool
Usage: apgdiff [options] <old_dump> <new_dump>
Another PostgreSQL Diff Tool is a simple PostgreSQL diff tool that is useful for schema upgrades. The tool compares two schema dump files and creates an SQL output file that is (after some hand-made modifications) suitable for upgrades of old schemata.
--version displays apgdiff version --add-defaults adds DEFAULT ... in case new column has NOT NULL constraint but no default value (the default value is dropped later) --add-transaction adds START TRANSACTION and COMMIT TRANSACTION to the generated diff file --ignore-function-whitespace ignores multiple spaces and new lines when comparing content of functions · WARNING: this may cause functions to appear to be same in cases they are not, so use this feature only if you know what you are doing --ignore-start-with ignores START WITH modifications on SEQUENCEs (default is not to ignore these changes) --in-charset-name <charset> charset that should be used for reading input files (standard charset name supported by Java, default is UTF-8) --out-charset-name <charset> charset that should be used for writing output (standard charset name supported by Java, default is UTF-8) --output-ignored-statements outputs information about DDL statements that apgdiff ignores at this moment (it will not output any SELECT, INSERT, UPDATE and/or DELETE statements) --list-charsets lists all supported charsets
Miroslav Šulc <email@example.com>. This manual page was written by Christoph Berg <firstname.lastname@example.org> for the Debian system (but may be used by others). 11/01/2010 APGDIFF(1)