From: Dai, Tino <tdai@loc.gov>
To: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Comparing 2 data base or 2 tables
Date: Mon, 28 Jun 2021 11:39:03 +0000
Message-ID: <1624880344134.31014@loc.gov> (raw)
In-Reply-To: <EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com>
References: <CALhHtcDip7W6WvDdW6JNAYChpYfO0An8CMFCejLpAY9yP_kUjA@mail.gmail.com>
<CAOBaU_ZS2_3_TCW7TZBJMb9kRZMS+oLssU=HwVTQDZ0L1GWYTw@mail.gmail.com>
<DBAPR01MB66628936B4775452DAEBBAD7CA039@DBAPR01MB6662.eurprd01.prod.exchangelabs.com>
<EAC73B19-3E0C-42DA-85D6-AEF9BECDA7DA@jakobs.com>
?If you are on a mac, you can use a tool called diff
-T
________________________________
From: Holger Jakobs <holger@jakobs.com>
Sent: Monday, June 28, 2021 7:26 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
Dump them using pg_dump and compare the files.
Am 28. Juni 2021 13:12:26 MESZ schrieb koff10 <koff10@hotmail.com>:
Hi All,
I am in trouble with a production database. So, I'm looking for a script or tools comparing 2 postgre database schemas
and extract data differences.
I need a little help please.
thanks lot.
koff Berta
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tdai@loc.gov, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Comparing 2 data base or 2 tables
In-Reply-To: <1624880344134.31014@loc.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox