Re: Comparing 2 data base or 2 tables

From: Mukesh Rajpurohit <vivasvan1902(at)gmail(dot)com>
To: koff10 <koff10(at)hotmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Comparing 2 data base or 2 tables
Date: 2021-06-28 12:04:24
Message-ID: CAL+ptADGg_TKnaLEUBZRdpqoq_U6fOa3qDgzgr=DfWsbkbF2Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)hotmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message koff10 2021-06-28 13:22:29 Re: Comparing 2 data base or 2 tables
Previous Message Ron 2021-06-28 11:56:40 Re: Comparing 2 data base or 2 tables