Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 2D9D16380ED
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 29 Apr 2009 09:54:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 71211-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 29 Apr 2009 09:53:34 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f163.google.com (mail-bw0-f163.google.com
	[209.85.218.163])
	by mail.postgresql.org (Postfix) with ESMTP id 0C4A663FA92
	for <pgsql-sql@postgresql.org>; Wed, 29 Apr 2009 09:33:51 -0300 (ADT)
Received: by bwz7 with SMTP id 7so1198992bwz.19
	for <pgsql-sql@postgresql.org>; Wed, 29 Apr 2009 05:33:49 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=HUKB+wYRCvjyjBjzLsZwmUiBxB+Ake9Qk+qI9Vky49M=;
	b=nG5ofGEcdhJuYKrmbeEQfXVqUpDkV7RyC9VLhcvX2iRuKLq5I1jMNBcMNUrHjGqZLd
	rO83cOkCQM+A7UjOtStcUXoqDOHg+pfVeDcGYN5RWrjgOtS4lepUZV4/AkX4zGUOizw1
	z9no87wA8ibPGjcDk9TwYCKa32r5BVvLP7fn4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=ePkfgcYoER0dpjrm41BpHChhcWwQ/Wk+CMvc8bVgYEHgRlI4Gf9lwOZyScyXwADZ1y
	tp9rFRrAi6iuDsFTpijHepXtn6rj62ToFO8XNbBeghPbcS02QWP+pIDS+3qr91XojVZD
	7hD+bcMk0ffImQpO0R+Kc0sf4jcsMT//Hp6nw=
MIME-Version: 1.0
Received: by 10.223.122.15 with SMTP id j15mr183805far.10.1241008429459; Wed,
	29 Apr 2009 05:33:49 -0700 (PDT)
In-Reply-To: <e13d0d10904282339r1f853e1cpe3514e53ae47e5ef@mail.gmail.com>
References: <e13d0d10904282339r1f853e1cpe3514e53ae47e5ef@mail.gmail.com>
Date: Wed, 29 Apr 2009 14:33:49 +0200
Message-ID: <cc4f12900904290533x5e1871fdu8f8a27dc956ca616@mail.gmail.com>
Subject: Re: Comparing two tables of different database
From: Pawel Socha <pawel.socha@gmail.com>
To: Nicholas I <nicholas.domnic.i@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/136
X-Sequence-Number: 32482

2009/4/29 Nicholas I <nicholas.domnic.i@gmail.com>:
> Hi,
>
> =A0 can anybody me suggest me, how to compare two tables of different
> database.
>
> -Nicholas I
>

what you mean 'different database' :)
diffrent version, 2 instance ?

Maybe this help:
http://www.postgresql.org/docs/current/static/dblink.html


--=20
Pawel Socha