Re: Comparing two (largish) tables on different servers - Mailing list pgsql-sql

From Sam Mason
Subject Re: Comparing two (largish) tables on different servers
Date
Msg-id 20041110091821.GD25775@sam.samason.me.uk
Whole thread Raw
In response to Comparing two (largish) tables on different servers  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Responses Re: Comparing two (largish) tables on different servers  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Gregory S. Williamson wrote:
>Is there any way to do this from inside postgres that anyone knows of
>? I looked through the manual and the contrib stuff and didn't see
>much ...

Not really "inside postgres"; but could you do something like:
 mkfifo db1 psql -h "db1" -t -q -c "$query" > db1 mkfifo db2 psql -h "db2" -t -q -c "$query" > db2 diff -u -0 db1 db2

That should work with most shells under Unix. . .

Have fun, Sam


pgsql-sql by date:

Previous
From: "Riccardo G. Facchini"
Date:
Subject: Re: A transaction in transaction? Possible?
Next
From: Michael Fuhr
Date:
Subject: Re: A transaction in transaction? Possible?