MIME-Version: 1.0
References: <CAA23Sdt01OOLWHdKNdHSk_372LXNPrv13FQ137SCfPjs2dTNDg@mail.gmail.com>
 <CAGsyd8WPvqiUHnexV97vJeoMimMuLKdapz_EuQFyRF5o9=pqNQ@mail.gmail.com>
In-Reply-To: <CAGsyd8WPvqiUHnexV97vJeoMimMuLKdapz_EuQFyRF5o9=pqNQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 3 Sep 2024 13:31:14 -0400
Message-ID: <CANzqJaByNsyZwz8fjuYUXLUUmeSXkAutiUja20Y1kOb6-gjLTA@mail.gmail.com>
Subject: Re: Table and data comparison
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004a8e4106213a6d70"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaByNsyZwz8fjuYUXLUUmeSXkAutiUja20Y1kOb6-gjLTA%40mail.gmail.com>
Precedence: bulk

--0000000000004a8e4106213a6d70
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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

On Tue, Sep 3, 2024 at 12:36=E2=80=AFPM 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
>>
>

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

--0000000000004a8e4106213a6d70
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>postgres_fdw will be required if the tables are in se=
parate databases.</div><div><br></div><div dir=3D"ltr">On Tue, Sep 3, 2024 =
at 12:36=E2=80=AFPM David Mullineux &lt;<a href=3D"mailto:dmullx@gmail.com"=
>dmullx@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><p dir=3D"ltr">Yes, PostgreSQL.=
<br>
Why not just do this via SQL join ?<br>
</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, 3 Sept 2024, 17:34 arun chirappurath, &lt;<a href=3D"mailto:arunsnmimt@gm=
ail.com" target=3D"_blank">arunsnmimt@gmail.com</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi All,<di=
v dir=3D"auto"><br></div><div dir=3D"auto">Do we have any open-source utili=
ty to compare two table data not structure and then provide some sort of re=
ports?</div><div dir=3D"auto"><br></div><div dir=3D"auto">Row by row compar=
ison</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</div><div d=
ir=3D"auto">Arun=C2=A0</div></div>
</blockquote></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Death to America, and butter sauce.<div>Iraq lobster!</div><=
/div></div></div>

--0000000000004a8e4106213a6d70--