apgdiff(1)
NAME
apgdiff - Another PostgreSQL Diff Tool
SYNOPSIS
Usage: apgdiff [options] <old_dump> <new_dump>
DESCRIPTION
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.
OPTIONS
- --version
- displays apgdiff version
- --add-defaults
- adds DEFAULT ... in case new column 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) - --out-charset-name <charset>
- charset that should be used for writing output (standard charset
name supported by Java) - --quote-names
- adds quotes to names
AUTHOR
- Miroslav ulc <miroslav.sulc@startnet.cz>. This manual page was written
by Christoph Berg <myon@debian.org> for the Debian system (but may be
used by others).