Обсуждение: Table and data comparison

Поиск
Список
Период
Сортировка

Table and data comparison

От
arun chirappurath
Дата:
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

От
David Mullineux
Дата:

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

От
Ron Johnson
Дата:
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!

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.