Man Linux: Main Page and Category List

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 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)

       --out-charset-name <charset>
           charset that should be used for writing output (standard charset
           name supported by Java)

       --quote-names
           adds quotes to names

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).

                                  05/22/2010