Scroll to navigation
APGDIFF(1) |
User Commands |
APGDIFF(1) |
NAME¶
apgdiff - Another PostgreSQL Diff Tool
SYNOPSIS¶
apgdiff [options] <old_dump> <new_dump>
OPTIONS¶
--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 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: do not ignore
these changes).
--ignore-schema-creation:¶
- Removes the need of CREATE SCHEMA command on the input schemas
--in-charset-name <charset>:¶
- charset that should be used for reading input files (standard charset name
supported by Java; the 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