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.
displays apgdiff version
adds DEFAULT ... in case new column NOT NULL constraint but no
default value (the default value is dropped later)"
adds START TRANSACTION and COMMIT TRANSACTION to the generated diff
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
ignores START WITH modifications on SEQUENCEs (default is not to
ignore these changes)
charset that should be used for reading input files (standard
charset name supported by Java)
charset that should be used for writing output (standard charset
name supported by Java)
adds quotes to names
Miroslav Åulc <firstname.lastname@example.org>. This manual page was written
by Christoph Berg <email@example.com> for the Debian system (but may be
used by others).