Re: Comparing databases

Navicat has built-in support for schema synchronization. It's pretty
good.

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On Jan 11, 2006, at 1:34 PM, Tom Lane wrote:

> "Sugrue, Sean" <Sean.Sugrue@analog.com> writes:
>> Does anyone know how to structurally compare a list of tables
>> between two different databases without going
>> through them one by one?
>
> You might try "pg_dump -s" on both databases and diff the output.
> Not a perfect tool but it will serve for minor differences.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>