public inbox for [email protected]  

help / color / mirror / Atom feed

Table and data comparison
3+ messages / 3 participants
[nested] [flat]

* Table and data comparison
@ 2024-09-03 16:34  arun chirappurath <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: arun chirappurath @ 2024-09-03 16:34 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Table and data comparison
@ 2024-09-03 16:36  David Mullineux <[email protected]>
  parent: arun chirappurath <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: David Mullineux @ 2024-09-03 16:36 UTC (permalink / raw)
  To: arun chirappurath <[email protected]>; +Cc: [email protected]

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

On Tue, 3 Sept 2024, 17:34 arun chirappurath, <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Table and data comparison
@ 2024-09-03 17:31  Ron Johnson <[email protected]>
  parent: David Mullineux <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Ron Johnson @ 2024-09-03 17:31 UTC (permalink / raw)
  To: pgsql-generallists.postgresql.org <[email protected]>

postgres_fdw will be required if the tables are in separate databases.

On Tue, Sep 3, 2024 at 12:36 PM David Mullineux <[email protected]> wrote:

> Yes, PostgreSQL.
> Why not just do this via SQL join ?
>
> On Tue, 3 Sept 2024, 17:34 arun chirappurath, <[email protected]>
> 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!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2024-09-03 17:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-03 16:34 Table and data comparison arun chirappurath <[email protected]>
2024-09-03 16:36 ` David Mullineux <[email protected]>
2024-09-03 17:31   ` Ron Johnson <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox