Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 59A6C63F2DE for ; Wed, 29 Apr 2009 23:21:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66995-04-2 for ; Wed, 29 Apr 2009 23:21:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out3.iinet.net.au (outbound.icp-qv1-irony-out3.iinet.net.au [203.59.1.148]) by mail.postgresql.org (Postfix) with ESMTP id 59A64635A05 for ; Wed, 29 Apr 2009 21:51:18 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AioDADNv+El8q5lc/2dsb2JhbAAIgh4tzSqDdQU X-IronPort-AV: E=Sophos;i="4.40,268,1238947200"; d="scan'208,217";a="429775846" Received: from unknown (HELO [10.1.1.4]) ([124.171.153.92]) by outbound.icp-qv1-irony-out3.iinet.net.au with ESMTP; 30 Apr 2009 06:20:03 +0800 Cc: Nicholas I , pgsql-sql@postgresql.org Message-Id: <328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com> From: Adam Ruth To: Pawel Socha In-Reply-To: Content-Type: multipart/alternative; boundary=Apple-Mail-14-743398008 Mime-Version: 1.0 (Apple Message framework v930.3) Subject: Re: Comparing two tables of different database Date: Thu, 30 Apr 2009 08:20:02 +1000 References: X-Mailer: Apple Mail (2.930.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200904/139 X-Sequence-Number: 32485 --Apple-Mail-14-743398008 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit The simple answer is to pg_dump both tables and compare the output with diff. Other than that, I think you'll need a custom program. On 29/04/2009, at 10:33 PM, Pawel Socha wrote: > 2009/4/29 Nicholas I : >> Hi, >> >> 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 > > > -- > Pawel Socha > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql --Apple-Mail-14-743398008 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable The simple = answer is to pg_dump both tables and compare the output with = diff.

Other than that, I = think you'll need a custom program.

On 29/04/2009, at 10:33 PM, Pawel = Socha wrote:

2009/4/29 Nicholas I <nicholas.domnic.i@gmail.com>:
Hi,

  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


-- =
Pawel Socha

--
Sent via pgsql-sql mailing list = (pgsql-sql@postgresql.org)
To make changes to your = subscription:
http://www.postgresql.org/mailpref/pgsql-sql

= --Apple-Mail-14-743398008--