How to compare data between two databases in PostgreSQL?

There are several tools out there: (note that most of these tools can only compare structure, but not data) Free Ones: pgquarrel: http://eulerto.github.io/pgquarrel (schema diff) apgdiff http://apgdiff.com/ (schema diff) Liquibase (Cross DBMS): http://www.liquibase.org (schema diff) pgAdmin https://www.pgadmin.org (schema diff in pgAdmin4) WbDataDiff (Cross DBMS): http://www.sql-workbench.net/manual/compare-commands.html#command-data-diff (data diff) WbSchemaDiff (Cross DBMS): http://www.sql-workbench.net/manual/compare-commands.html Migra https://migra.djrobstep.com/ (schema diff) … Read more