My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is pretty good and has all the features we are looking for but is full of bugs and creates much head ache.
Case Studio?
I love Case Studio (www.casestudio.com). It's inexpensive, well-supported, easy to use. Problem is that it doesn't do the DDL diff that he wants. I was looking for exactly the same feature/tool last year to build update scripts for client schemas.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
