table of contents
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
--ignore-start-with
•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)
--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
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).10/31/2010 |