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

Comparing databases

From: "Sugrue, Sean" <Sean(dot)Sugrue(at)analog(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Comparing databases
Date: 2006-01-11 20:30:05
Message-ID: 8FDC0F9BE1F91D44BE964AA54AAA67B61969FD45@wilmexm3.ad.analog.com (view raw or flat)
Thread:
Lists: pgsql-novice
To all,

I have two databases which need to be the same structurally. However
members on my team have gone ahead and 
made structural changes to one and not the other. I am trying to sync up
the database structure and I can't copy one to 
the other. Does anyone know how to structurally compare a list of tables
between two different databases without going
through them one by one?

Sean

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-01-11 20:34:39
Subject: Re: Comparing databases
Previous:From: Michael FuhrDate: 2006-01-11 20:18:04
Subject: Re: Removing duplicate entries

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