Postgres Pro
Downloads
Home   >   mailing lists

Re: Comparing two tables of different database - Mailing list pgsql-sql

From Adam Ruth
Subject Re: Comparing two tables of different database
Date
Msg-id 328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com
Whole thread Raw
In response to Re: Comparing two tables of different database  (Pawel Socha <pawel.socha@gmail.com>)
Responses Re: Comparing two tables of different database
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Comparing two tables of different database
Next
From: Jasen Betts
Date:
Subject: Re: Comparing two tables of different database