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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
