Linux Certif

Toute la documentation sur la certification Linux LPI

apgdiff

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