'\" t
.\" Title: apgdiff
.\" Author: [see the "AUTHOR" section]
.\" Generator: DocBook XSL Stylesheets v1.75.2
.\" Date: 10/31/2010
.\" Manual: \ \&
.\" Source: \ \&
.\" Language: English
.\"
.TH "APGDIFF" "1" "10/31/2010" "\ \&" "\ \&"
.\" -----------------------------------------------------------------
.\" * 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]
.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
.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
.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
\-\-list\-charsets
.RS 4
lists all supported charsets
.RE
.SH "AUTHOR"
.sp
Miroslav Ć ulc \&. This manual page was written by Christoph Berg for the Debian system (but may be used by others)\&.