This is the command apgdiff that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator
PROGRAM:
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
Use apgdiff online using onworks.net services
