Skip site navigation (1) Skip section navigation (2)

Re: Comparing databases

From: Brendan Duddridge <brendan(at)clickspace(dot)com>
To: "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Comparing databases
Date: 2006-01-12 04:50:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Navicat has built-in support for schema synchronization. It's pretty  

Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan(at)clickspace(dot)com

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

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

> "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)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

In response to


  • Forums at 2006-01-12 13:38:43 from Mark Campbell

pgsql-novice by date

Next:From: tmorelliDate: 2006-01-12 12:27:58
Subject: A question about pages. Still not clear
Previous:From: Michael FuhrDate: 2006-01-12 04:48:30
Subject: Re: Removing duplicate entries

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group