APGDIFF(1)

🎀 apgdiff 🎀

okay so apgdiff is another PostgreSQL diff tool 💖 and it compares two dumps so you can see what changed between them. bestie, this page is literally everything you need to know 💅

✨ NAME ✨

apgdiff - Another PostgreSQL Diff Tool 🦋

✨ SYNOPSIS ✨

apgdiff [options] <old_dump> <new_dump>

so you toss in your options, then the old dump, then the new dump. easy peasy 🌸

✨ OPTIONS ✨

• --version — 💖 shows you which apgdiff version you're running
• --add-defaults — adds DEFAULT ... when a new column has a NOT NULL constraint but no default value. the default gets dropped again later 🧚
• --add-transaction — wraps your generated diff file with START TRANSACTION and COMMIT TRANSACTION ✨
• --ignore-function-whitespace — ignores extra spaces and new lines when comparing function bodies 🙈

🚨 WARNING: this can make functions look the same when they actually aren't, so only use this one if you really know what you're doing, bestie 😭

• --ignore-start-with — ignores START WITH changes on SEQUENCEs. by default these changes are not ignored 🍓
• --ignore-schema-creation — you don't need a CREATE SCHEMA command on the input schemas anymore 🌈
• --in-charset-name <charset> — the charset used for reading input files. it has to be a standard charset name that Java supports, and the default is UTF-8 💜
• --out-charset-name <charset> — the charset used for writing output. same deal: standard Java charset name, and the default is UTF-8 🫶
• --output-ignored-statements — spills the tea on which DDL statements apgdiff is ignoring right now. it won't output any SELECT, INSERT, UPDATE and/or DELETE statements though 👑
• --ignore-slony-triggers — when parsing SQL statements, ignores the Slony triggers named _slony_logtrigger and _slony_denyaccess 🦋
• --list-charsets — lists every charset that's supported ⭐

---

that's the whole vibe, bestie 🎀 apgdiff 2.7.0-1, January 2022, APGDIFF(1) 💖🧚