npm

apgdiff

Compares PostgreSQL database schemas and generates migration SQL

brewmacoslinux
Try with needOr install directly
Source

About

Another PostgreSQL diff tool

Commands

apgdiff

Examples

Compare two SQL schema files and generate migration script$ apgdiff old_schema.sql new_schema.sql > migration.sql
Generate diff between two PostgreSQL database dumps$ apgdiff --ignore-startswith pg_dump_old.sql pg_dump_new.sql
Compare schemas and output to file with specific options$ apgdiff --add-defaults old.sql new.sql -o diff_output.sql