Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparing 2 data base or 2 tables - Mailing list pgsql-admin

From Mukesh Rajpurohit
Subject Re: Comparing 2 data base or 2 tables
Date
Msg-id CAL+ptADGg_TKnaLEUBZRdpqoq_U6fOa3qDgzgr=DfWsbkbF2Bg@mail.gmail.com
Whole thread Raw
In response to Comparing 2 data base or 2 tables  (koff10 <koff10@hotmail.com>)
Responses Re: Comparing 2 data base or 2 tables
List pgsql-admin
Tree view
You may use EXCEPT keyword to compare two tables in two databases, plz use postgres_fdw for connectivity.

Thanks
Mukesh

On Mon, Jun 28, 2021, 4:42 PM koff10 <koff10@hotmail.com> wrote:

Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.

koff Berta

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Comparing 2 data base or 2 tables
Next
From: koff10
Date:
Subject: Re: Comparing 2 data base or 2 tables