NAME

       apgdiff - Another PostgreSQL Diff Tool

SYNOPSIS

       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

       --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 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                                 APGDIFF(1)