Thread: Table and data comparison

Table and data comparison

From
arun chirappurath
Date:
Hi All,

Do we have any open-source utility to compare two table data not structure and then provide some sort of reports?

Row by row comparison

Thanks,
Arun 

Re: Table and data comparison

From
David Mullineux
Date:

Yes, PostgreSQL.
Why not just do this via SQL join ?

On Tue, 3 Sept 2024, 17:34 arun chirappurath, <arunsnmimt@gmail.com> wrote:
Hi All,

Do we have any open-source utility to compare two table data not structure and then provide some sort of reports?

Row by row comparison

Thanks,
Arun 

Re: Table and data comparison

From
Ron Johnson
Date:
postgres_fdw will be required if the tables are in separate databases.

On Tue, Sep 3, 2024 at 12:36 PM David Mullineux <dmullx@gmail.com> wrote:

Yes, PostgreSQL.
Why not just do this via SQL join ?

On Tue, 3 Sept 2024, 17:34 arun chirappurath, <arunsnmimt@gmail.com> wrote:
Hi All,

Do we have any open-source utility to compare two table data not structure and then provide some sort of reports?

Row by row comparison

Thanks,
Arun 


--
Death to America, and butter sauce.
Iraq lobster!