How can I compare the data which is present in different database in postgresql.
For example, I have 2 databases db1 & db2
Both have the same tables like tb1 tb2 tb3
I want to compare which table has different record.
Postgresql how to compare the tables which are present in different database
postgresqlpostgresql-9.4
Related Question
- PostgreSQL Schema – Identify Function Calls Across Databases
- Postgresql – Copying Tables (partly replicating) databases remotely
- PostgreSQL – Is It Possible to Match Two Different Data Types?
- PostgreSQL – Specify Column Positions in pg_dump Generated Insert Statements
- Postgresql – Trigger function to update data from one table to another table with different servers in PostgreSQL
- PostgreSQL Trigger – Creating Trigger from One Database Table to Another
- PostgreSQL Database Comparison – How to Check if Two PostgreSQL Databases on Different Servers are Identical
Best Answer
you could use the
postgres_fdwto link the 2 dbs together and execute queries to compare the different tables as if they we're in the same db.see the documentation on postgres_fdw for examples.
Note, this requires that you will be able to connect from one db to the other remotely. and queries might be resource intensive (as you are basically pulling the data of the remote table over the wire)