Man Linux: Main Page and Category List


       apgdiff - Another PostgreSQL Diff Tool


       Usage: apgdiff [options] <old_dump> <new_dump>


       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.


           displays apgdiff version

           adds DEFAULT ... in case new column NOT NULL constraint but no
           default value (the default value is dropped later)"

           adds START TRANSACTION and COMMIT TRANSACTION to the generated diff

           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

           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)

           adds quotes to names


       Miroslav Åulc <>. This manual page was written
       by Christoph Berg <> for the Debian system (but may be
       used by others).