From: Adam Ruth <adamruth@mac.com>
To: Pawel Socha <pawel.socha@gmail.com>
Cc: Nicholas I <nicholas.domnic.i@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Comparing two tables of different database
Date: Thu, 30 Apr 2009 08:20:02 +1000
Message-ID: <328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com> (raw)
In-Reply-To: <cc4f12900904290533x5e1871fdu8f8a27dc956ca616@mail.gmail.com>
References: <e13d0d10904282339r1f853e1cpe3514e53ae47e5ef@mail.gmail.com>
<cc4f12900904290533x5e1871fdu8f8a27dc956ca616@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adamruth@mac.com, pawel.socha@gmail.com, nicholas.domnic.i@gmail.com
Subject: Re: Comparing two tables of different database
In-Reply-To: <328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox