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.domni...@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 via email to