A good database modeling tool for PostgreSQL? [clo

问题:

PostgreSQL comes with the excellent pgAdmin-tool for managing the database but lacks GUI data-modeling utility?

I found this list: http://www.databaseanswers.org/modelling_tools.htm but don't have time to evaluate them.

Which one do YOU recommend?

回答1:

pgModeler looks promising: http://pgmodeler.com.br

回答2:

WWW SQL Designer is a great lightweight modeling tool, and it supports PostgreSQL.

SQuirreL also seems nice, I haven't tried it though.

回答3:

You might also want to have a look at Power*Architect.

http://www.sqlpower.ca/page/architect

回答4:

The MySQL workbench is a fine modeling tool that's free, but you'll have to modify the SQL it generates for PostgreSQL.

If you have to pay, ERWin is a standard.

回答5:

Commercial tools:

dbwrench

Embarcadero ER Studio

回答6:

I'm satisfied since years with PostgreSQL Maestro. It's a mature solution and easy to use, but comprehensive.