Table and data comparison

Started by arun chirappurathover 1 year ago3 messagesgeneral
Jump to latest
#1arun chirappurath
arunsnmimt@gmail.com

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

#2David Mullineux
dmullx@gmail.com
In reply to: arun chirappurath (#1)
Re: Table and data comparison

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

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

Show quoted text

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

#3Ron
ronljohnsonjr@gmail.com
In reply to: David Mullineux (#2)
Re: Table and data comparison

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!