pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedComparing 2 data base or 2 tables
8+ messages / 6 participants
[nested] [flat]
* Comparing 2 data base or 2 tables
@ 2021-06-28 11:12 koff10 <koff10@hotmail.com>
2021-06-28 11:26 ` Re: Comparing 2 data base or 2 tables Holger Jakobs <holger@jakobs.com>
2021-06-28 12:04 ` Re: Comparing 2 data base or 2 tables Mukesh Rajpurohit <vivasvan1902@gmail.com>
2021-06-29 11:53 ` Re: Comparing 2 data base or 2 tables Vineet Naik <naikvin@gmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: koff10 @ 2021-06-28 11:12 UTC (permalink / raw)
To: koff10@hotmail.com; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
@ 2021-06-28 11:26 ` Holger Jakobs <holger@jakobs.com>
2021-06-28 11:39 ` Re: Comparing 2 data base or 2 tables Dai, Tino <tdai@loc.gov>
2021-06-28 11:41 ` Re: Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2 siblings, 2 replies; 8+ messages in thread
From: Holger Jakobs @ 2021-06-28 11:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 -
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2021-06-28 11:26 ` Re: Comparing 2 data base or 2 tables Holger Jakobs <holger@jakobs.com>
@ 2021-06-28 11:39 ` Dai, Tino <tdai@loc.gov>
1 sibling, 0 replies; 8+ messages in thread
From: Dai, Tino @ 2021-06-28 11:39 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
?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 -
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2021-06-28 11:26 ` Re: Comparing 2 data base or 2 tables Holger Jakobs <holger@jakobs.com>
@ 2021-06-28 11:41 ` koff10 <koff10@hotmail.com>
2021-06-28 11:56 ` Re: Comparing 2 data base or 2 tables Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: koff10 @ 2021-06-28 11:41 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org
Thanks lot,
I did not think about it
koff
Le 28/06/2021 à 13:26, Holger Jakobs a écrit :
> 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 -
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2021-06-28 11:26 ` Re: Comparing 2 data base or 2 tables Holger Jakobs <holger@jakobs.com>
2021-06-28 11:41 ` Re: Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
@ 2021-06-28 11:56 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Ron @ 2021-06-28 11:56 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Meld is an excellnet file compare program.
On 6/28/21 6:41 AM, koff10 wrote:
> Thanks lot,
> I did not think about it
> koff
>
> Le 28/06/2021 à 13:26, Holger Jakobs a écrit :
>> 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 -
>
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
@ 2021-06-28 12:04 ` Mukesh Rajpurohit <vivasvan1902@gmail.com>
2021-06-28 13:22 ` Re: Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Mukesh Rajpurohit @ 2021-06-28 12:04 UTC (permalink / raw)
To: koff10 <koff10@hotmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
You may use EXCEPT keyword to compare two tables in two databases, plz use
postgres_fdw for connectivity.
Thanks
Mukesh
On Mon, Jun 28, 2021, 4:42 PM koff10 <koff10@hotmail.com> wrote:
>
> 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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2021-06-28 12:04 ` Re: Comparing 2 data base or 2 tables Mukesh Rajpurohit <vivasvan1902@gmail.com>
@ 2021-06-28 13:22 ` koff10 <koff10@hotmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: koff10 @ 2021-06-28 13:22 UTC (permalink / raw)
To: Mukesh Rajpurohit <vivasvan1902@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks all for your feed back
@Mukesh , I daily use postgres_fdw but not plz . How does it work?
Le 28/06/2021 à 14:04, Mukesh Rajpurohit a écrit :
> You may use EXCEPT keyword to compare two tables in two databases, plz
> use postgres_fdw for connectivity.
>
> Thanks
> Mukesh
>
> On Mon, Jun 28, 2021, 4:42 PM koff10 <koff10@hotmail.com
> <mailto:koff10@hotmail.com>> wrote:
>
>
> 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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Comparing 2 data base or 2 tables
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
@ 2021-06-29 11:53 ` Vineet Naik <naikvin@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Vineet Naik @ 2021-06-29 11:53 UTC (permalink / raw)
To: koff10 <koff10@hotmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, Jun 28, 2021 at 4:42 PM koff10 <koff10@hotmail.com> wrote:
>
>
> 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.
pgAdmin 4 comes with a schema diff tool that's pretty good -
https://www.pgadmin.org/docs/pgadmin4/5.4/schema_diff.html
> I need a little help please.
> thanks lot.
>
> koff Berta
~ Vineet
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2021-06-29 11:53 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-28 11:12 Comparing 2 data base or 2 tables koff10 <koff10@hotmail.com>
2021-06-28 11:26 ` Holger Jakobs <holger@jakobs.com>
2021-06-28 11:39 ` Dai, Tino <tdai@loc.gov>
2021-06-28 11:41 ` koff10 <koff10@hotmail.com>
2021-06-28 11:56 ` Ron <ronljohnsonjr@gmail.com>
2021-06-28 12:04 ` Mukesh Rajpurohit <vivasvan1902@gmail.com>
2021-06-28 13:22 ` koff10 <koff10@hotmail.com>
2021-06-29 11:53 ` Vineet Naik <naikvin@gmail.com>
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