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.
-Nic
Hello
try to look on http://pgfoundry.org/forum/forum.php?forum_id=1392
regards
Pavel Stehule
2009/4/29 Nicholas I :
> Hi,
>
> can anybody me suggest me, how to compare two tables of different
> database.
>
> -Nicholas I
>
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make
Nicholas I, 29.04.2009 08:39:
Hi,
can anybody me suggest me, how to compare two tables of different
database.
Do you want to compare the data or the structure of the two tables?
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
htt
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
--
Hi,
can anybody me suggest me, how to compare two tables of different
database.
-Nicholas I
