Re: Tracking structural changes from psql

From: Daniel Vérité <daniel(at)invalid(dot)domain>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tracking structural changes from psql
Date: 2004-05-04 09:58:55
Message-ID: m3y8o88qe8.fsf@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike McGavin <jester(at)NOSPAM(dot)mcsnospam(dot)vuw(dot)acNOSPAM(dot)nz> writes:

> It also occurs to me that an even more useful utility might be one
> that stores the structural state of the database at a particular time
> (such as when I last updated the production server), and then generate
> a diff of SQL statements to update it to the current structural state.
> I don't suppose this already exists anywhere, does it?

You might want to try:

http://zongle.sourceforge.net/
http://pgdiff.sourceforge.net/
http://gborg.postgresql.org/project/pgdiff/projdisplay.php

--
Daniel Vérité - daniel at manitou dash mail dot org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-05-04 10:24:37 interval output format available that removes ambiguity ?
Previous Message Bastian 2004-05-04 08:50:38 Verhindern, dass im Mehrbenutzerbetrieb mit veralteten Daten gearbteitet wird