Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1slWWK-008MSs-OP
	for pgsql-general@arkaria.postgresql.org; Tue, 03 Sep 2024 16:36:45 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1slWWJ-00E02c-Sg
	for pgsql-general@arkaria.postgresql.org; Tue, 03 Sep 2024 16:36:44 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <dmullx@gmail.com>)
	id 1slWWJ-00E02U-Hl
	for pgsql-general@lists.postgresql.org; Tue, 03 Sep 2024 16:36:43 +0000
Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <dmullx@gmail.com>)
	id 1slWWH-000ULz-MY
	for pgsql-general@lists.postgresql.org; Tue, 03 Sep 2024 16:36:43 +0000
Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-5dcd8403656so3959220eaf.1
        for <pgsql-general@lists.postgresql.org>; Tue, 03 Sep 2024 09:36:41 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1725381400; x=1725986200; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=GNaM50biCEuZdeFUn/miLnp1WLpCUA9K0+S6CyUTP2M=;
        b=EDGJCF2PGFZzV/jNZqEa2j2GcZFf5P9+APGiyLdnw3619rMarNTcLqODCVcz6AOboP
         C3s0mLnk41WKc9Rl3zI2wiwcaJ9zQVnELnxxYGCWsQnsxZrO36ZSTEUAg4sPBO2pV0sy
         0oE36fV1ma0Av8u/WB7C7YnXlvNeB4BJheaBz4IlmQSATHNIbBpIg+92sXGMdxFdyNMN
         rzDaTsaptVhtXw6ySn5T1bmH7/lbz/2Urg+dJVYpJxu8iQASyFyOhwr07ywB/rHEFPzh
         Az3GZf1v3P/tS8vyXz2Ur712LF+bNaKm5MvqEZ/z/+G/3spO/BAxe/5DZYHveaCjgoqg
         cX9A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1725381400; x=1725986200;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=GNaM50biCEuZdeFUn/miLnp1WLpCUA9K0+S6CyUTP2M=;
        b=ezgo6ZK+LfM3yy+xWP9hXTy6EyAlUafT8VerphtAzMFabY/xz3V7LnwA4/7AIBHYv5
         Hzp3rwUqxF1GO/uOPnhs+oUchLwrqeRrkBbyZroqXNNkSetL37nlXkZYl3kcemqJ06tl
         GB64jSMjHyEjy5sXDxTXfwuF7vv+1bGx4T0TvAFHLLxShwj6G2KrDzeBAUAkOUSfPEhU
         8dHr1WQ/DROSumHGulD0XgUxUNUqgXW0nuHqVGxwW+nFtN1H6aY8JQ/kShF3vHvZP4Jp
         gL2Ap8q7FuzqMt6f4GtSiwvKIWnwFKstiV8ixQ8Or52t9RPh966RvpjZJ+S2QrKuj9wE
         GIlw==
X-Gm-Message-State: AOJu0YwJpgP0vNdGorp7ULoAs4oSTYfmQXePPVqO1buGJ92KAJY0z54D
	vWB+dzWsTvP5cl3sM5/5HmXTIZe5NrsL5gaITGyUG7DcPwd3sr5MtAZz0lFsZV+mEmk8OYa8n98
	1avScLz+tUhATtY9qDDUk6ym7Ybg=
X-Google-Smtp-Source: AGHT+IE7HbijjUMOTkj6/6T80ryC8xh/KLrZAGywmEpkdJL5qZVyZEOEw12Js56CXrI6Zf2zkOyH/ILZfCwiGDrr+Ec=
X-Received: by 2002:a05:6808:1184:b0:3d6:3214:861c with SMTP id
 5614622812f47-3df05d6a1efmr15012447b6e.13.1725381399797; Tue, 03 Sep 2024
 09:36:39 -0700 (PDT)
MIME-Version: 1.0
References: <CAA23Sdt01OOLWHdKNdHSk_372LXNPrv13FQ137SCfPjs2dTNDg@mail.gmail.com>
In-Reply-To: <CAA23Sdt01OOLWHdKNdHSk_372LXNPrv13FQ137SCfPjs2dTNDg@mail.gmail.com>
From: David Mullineux <dmullx@gmail.com>
Date: Tue, 3 Sep 2024 17:36:28 +0100
Message-ID: <CAGsyd8WPvqiUHnexV97vJeoMimMuLKdapz_EuQFyRF5o9=pqNQ@mail.gmail.com>
Subject: Re: Table and data comparison
To: arun chirappurath <arunsnmimt@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000006fea85062139a931"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAGsyd8WPvqiUHnexV97vJeoMimMuLKdapz_EuQFyRF5o9%3DpqNQ%40mail.gmail.com>
Precedence: bulk

--0000000000006fea85062139a931
Content-Type: text/plain; charset="UTF-8"

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
>

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

<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">arunsnmimt@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-=
left:1ex"><div dir=3D"auto">Hi All,<div dir=3D"auto"><br></div><div dir=3D"=
auto">Do we have any open-source utility to compare two table data not stru=
cture and then provide some sort of reports?</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">Row by row comparison</div><div dir=3D"auto"><br></div=
><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Arun=C2=A0</div></div>
</blockquote></div>

--0000000000006fea85062139a931--