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
September 2018 apgdiff 2.5.0~alpha.2-75-gcaaaed9-4