views:

174

answers:

4

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  A: 

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.

duffymo
+1  A: 

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

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

Alix Axel
+1  A: 

Commercial tools:

dbwrench

Embarcadero ER Studio

pcent
A: 

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

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

a_horse_with_no_name