X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A54163A1D98 for ; Wed, 10 Nov 2004 09:18:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63991-10 for ; Wed, 10 Nov 2004 09:18:22 +0000 (GMT) Received: from outmail.freedom2surf.net (outmail1.freedom2surf.net [194.106.33.237]) by svr1.postgresql.org (Postfix) with ESMTP id 06A603A3B73 for ; Wed, 10 Nov 2004 09:18:22 +0000 (GMT) Received: from sam.samason.me.uk (sam.samason.me.uk [195.137.31.118]) by outmail.freedom2surf.net (8.12.10/8.12.10) with ESMTP id iAA9ILnF025271 for ; Wed, 10 Nov 2004 09:18:22 GMT Received: by sam.samason.me.uk (Postfix, from userid 1000) id 72A34636BA; Wed, 10 Nov 2004 09:18:21 +0000 (GMT) Date: Wed, 10 Nov 2004 09:18:21 +0000 From: Sam Mason To: pgsql-sql@postgresql.org Subject: Re: Comparing two (largish) tables on different servers Message-ID: <20041110091821.GD25775@sam.samason.me.uk> Mail-Followup-To: pgsql-sql@postgresql.org References: <71E37EF6B7DCC1499CEA0316A256832801D4BAB0@loki.wc.globexplorer.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline In-Reply-To: <71E37EF6B7DCC1499CEA0316A256832801D4BAB0@loki.wc.globexplorer.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/100 X-Sequence-Number: 19419 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