Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 09DD663FD0C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 30 Apr 2009 18:45:55 -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 83887-01-3 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 30 Apr 2009 18:45:42 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.242])
	by mail.postgresql.org (Postfix) with ESMTP id 73776636763
	for <pgsql-sql@postgresql.org>; Wed, 29 Apr 2009 09:48:22 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c2so689369anc.28
	for <pgsql-sql@postgresql.org>; Wed, 29 Apr 2009 05:48:20 -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=we9StAycoPBNgls15vimnN0MN9GGBhPJmmD/khmCnw4=;
	b=LdWXpAmGtYJMFT9EI7J61M+s9bF+ioReFYpN6WB6G6pERsZJPlR/92V6Z+NaxIBq2Q
	ruYg5B4h4FW+Y9ZpUmT0pSWMpN4BNfgINvokNZMhZy0KvhCoCRINVFt0LiyR8/n6aR/a
	pGj/CvEkGOk6VnWZYlnOPAuHO+GPpcH/iqiyo=
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=XGJlMWJCr8xZJ9dvwsBcLhspWXDn1OwEaT8HBY7VqCPGDzHChVwhV31JJwGTW4rfgs
	RExuLQGHFiwr02hO3egHeSn6q3n5MaQAH14pSXTPi4NBP1mBPD5UwH+yXpaCc1JUuDOO
	d5Unu3LIqqbpmIZK2GDn0ndsAzBUQlXixmMuE=
MIME-Version: 1.0
Received: by 10.100.197.7 with SMTP id u7mr565086anf.108.1241009300841; Wed,
	29 Apr 2009 05:48:20 -0700 (PDT)
In-Reply-To: <e13d0d10904282339r1f853e1cpe3514e53ae47e5ef@mail.gmail.com>
References: <e13d0d10904282339r1f853e1cpe3514e53ae47e5ef@mail.gmail.com>
Date: Wed, 29 Apr 2009 09:48:20 -0300
Message-ID: <690707f60904290548x45df95fajaec3f0af203d05a1@mail.gmail.com>
Subject: Re: Comparing two tables of different database
From: Osvaldo Kussama <osvaldo.kussama@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/142
X-Sequence-Number: 32488

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


Two PostgreSQL databases: dblink
http://www.postgresql.org/docs/current/interactive/dblink.html

Distinct DBMS: dbilink
http://pgfoundry.org/projects/dbi-link/

Osvaldo