I use ER/Win for everything, but it is very pricey and it does not support PostgreSQL directly (only indirectly via ODBC).
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark Borins Sent: Monday, May 09, 2005 2:35 PM To: pgsql-general@postgresql.org Cc: rickb@rigadev.com Subject: [GENERAL] Data Modelling Tools
Postgres Newsgroup,
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.
For example, this tool doesn’t realize that in postgres you can’t add a column and set not null in one ALTER TABLE statement. So we are forced to manually comb through the SQL scripts it creates and fix the buggy statements.
So my question is, postgres general newsgroup, what database modelling tools do you use? Open source or commercial it doesn’t matter to me.