Re: Comparing two tables of different database

Поиск
Список
Период
Сортировка
От Adam Ruth
Тема Re: Comparing two tables of different database
Дата
Msg-id 328DDBBB-31C4-41D7-BF0E-5ADD732F2B9F@mac.com
обсуждение исходный текст
Ответ на Re: Comparing two tables of different database  (Pawel Socha <pawel.socha@gmail.com>)
Ответы Re: Comparing two tables of different database  (Joshua Tolley <eggyknap@gmail.com>)
Список 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.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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Comparing two tables of different database
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Comparing two tables of different database