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
>