APGDIFF(1) | APGDIFF(1) |
NAME¶
apgdiff - Another PostgreSQL Diff ToolSYNOPSIS¶
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¶
--versiondisplays 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)
--ignore-slony-triggers
when parsing SQL statements, ignores Slony triggers named
_slony_logtrigger and _slony_denyaccess
--list-charsets
lists all supported charsets
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).AUTHOR¶
Christoph Berg <myon@debian.org>Author.
07/02/2014 |