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
January 2022 | apgdiff 2.7.0-1 |