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