-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > can anyone recommend an open source tool for diffing schemas? You might want to check out the "same_schema" action of check_postgres.pl: http://bucardo.org/check_postgres/check_postgres.pl.html#same_schema http://bucardo.org/wiki/Check_postgres It allows you to compare the schemas of any number of databases to each other, and also compare a schema to an earlier version of itself, which can be used for things such as mailing a list of all schema changes in the last 24 hours, for example. - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201204171202 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAk+NlAUACgkQvJuQZxSWSsjhrwCg7VgFxG8xh6+pfup4QMSxdtKz tJcAoIkmtNRKOtYue5jRy9+FpTy6707u =wwqY -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general