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