[GENERAL] DDL diff utility?

[Steve Manes]

My company offers an ASP service for advertising companies using PG. 
For contractual reasons, each client gets its own replicated database. 
This presents a problem whenever a new feature/fix requires a DDL change 
which must be rolled out across N databases. Currently, we keep track of 
these changes via a central text file in CVS with manually entered DDL 
updates.  The problem is making sure that overworked developers actually 
log all these changes.

What would be better is a DDL 'diff' utility that would look at a master 
and target database and generate the necessary ALTER statements needed 
to make the target db look like the master.

Is anyone aware of such a tool for PG?  I've only found it for MSSQL.

---------------------------------------------=o&o>---------
Steve Manes          http://www.magpie.com
Brooklyn, NY


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend