Provided by: apgdiff_2.3-1_all bug


       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 has NOT NULL constraint but no default value (the
           default value is dropped later)

           adds START TRANSACTION and COMMIT TRANSACTION to the generated diff file

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

           outputs information about DDL statements that apgdiff ignores at this moment (it will
           not output any SELECT, INSERT, UPDATE and/or DELETE statements)

           lists all supported charsets


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

                                            11/01/2010                                 APGDIFF(1)