---
name: "apgdiff"
section: "1"
platform: "linux"
package: "apgdiff"
version: "2.7.0-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/apgdiff"
---

# apgdiff(1)

Another PostgreSQL Diff Tool

## NAME

apgdiff - Another PostgreSQL Diff Tool

## SYNOPSIS

**apgdiff** \[*options*\] *\<old\_dump\> \<new\_dump\>*

## 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 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: do not ignore these changes).

### --ignore-schema-creation:

-

  Removes the need of CREATE SCHEMA command on the input schemas

### --in-charset-name \<charset\>:

-

  charset that should be used for reading input files (standard charset name supported by Java; the 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