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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
you could use the
postgres_fdw to 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)