Re: Comparing 2 data base or 2 tables

From: "Dai, Tino" <tdai(at)loc(dot)gov>
To: Holger Jakobs <holger(at)jakobs(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Comparing 2 data base or 2 tables
Date: 2021-06-28 11:39:03
Message-ID: 1624880344134.31014@loc.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

?If you are on a mac, you can use a tool called diff

-T

________________________________
From: Holger Jakobs <holger(at)jakobs(dot)com>
Sent: Monday, June 28, 2021 7:26 AM
To: pgsql-admin(at)lists(dot)postgresql(dot)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(at)hotmail(dot)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 -

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message koff10 2021-06-28 11:41:14 Re: Comparing 2 data base or 2 tables
Previous Message Holger Jakobs 2021-06-28 11:26:04 Re: Comparing 2 data base or 2 tables