'\" t
.\"     Title: apgdiff
.\"    Author: Christoph Berg <myon@debian.org>
.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
.\"      Date: 07/02/2014
.\"    Manual: \ \&
.\"    Source: \ \&
.\"  Language: English
.\"
.TH "APGDIFF" "1" "07/02/2014" "\ \&" "\ \&"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
apgdiff \- Another PostgreSQL Diff Tool
.SH "SYNOPSIS"
.sp
Usage: apgdiff [options] <old_dump> <new_dump>
.SH "DESCRIPTION"
.sp
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\&.
.SH "OPTIONS"
.PP
\-\-version
.RS 4
displays apgdiff version
.RE
.PP
\-\-add\-defaults
.RS 4
adds DEFAULT \&... in case new column has NOT NULL constraint but no default value (the default value is dropped later)
.RE
.PP
\-\-add\-transaction
.RS 4
adds START TRANSACTION and COMMIT TRANSACTION to the generated diff file
.RE
.PP
\-\-ignore\-function\-whitespace
.RS 4
ignores multiple spaces and new lines when comparing content of functions
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
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
.RE
.RE
.PP
\-\-ignore\-start\-with
.RS 4
ignores START WITH modifications on SEQUENCEs (default is not to ignore these changes)
.RE
.PP
\-\-in\-charset\-name <charset>
.RS 4
charset that should be used for reading input files (standard charset name supported by Java, default is UTF\-8)
.RE
.PP
\-\-out\-charset\-name <charset>
.RS 4
charset that should be used for writing output (standard charset name supported by Java, default is UTF\-8)
.RE
.PP
\-\-output\-ignored\-statements
.RS 4
outputs information about DDL statements that apgdiff ignores at this moment (it will not output any SELECT, INSERT, UPDATE and/or DELETE statements)
.RE
.PP
\-\-ignore\-slony\-triggers
.RS 4
when parsing SQL statements, ignores Slony triggers named _slony_logtrigger and _slony_denyaccess
.RE
.PP
\-\-list\-charsets
.RS 4
lists all supported charsets
.RE
.SH "AUTHOR"
.sp
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)\&.
.SH "AUTHOR"
.PP
\fBChristoph Berg\fR <\&myon@debian\&.org\&>
.RS 4
Author.
.RE