From: | Adam Ruth <adamruth(at)mac(dot)com> |
---|---|
To: | Pawel Socha <pawel(dot)socha(at)gmail(dot)com> |
Cc: | Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Comparing two tables of different database |
Date: | 2009-04-29 22:20:02 |
Message-ID: | 328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)domnic(dot)i(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Tolley | 2009-04-30 03:37:48 | Re: Comparing two tables of different database |
Previous Message | Chris Bovitz | 2009-04-29 22:18:21 | freeing memory after fetch all |