Re: Tracking structural changes from psql

Mike McGavin <jester@NOSPAM.mcsnospam.vuw.acNOSPAM.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