Might want to link to this article from the downloads article.
Looks polished but expensive, not yet tried - http://www.datanamic.com/dezign/compareeditions.html
More from the PostgreSQL wiki,
- Data Architect - based on website does not look good
- Open System Architect - free looks ok
- Power*Architect
- dbwrench
- Datastudio
- xml to DDL
- DbDesigner fork
- Toad Data Modeler
- DeZign for Database
- PostgreSQL Maestro
- WaveMaker Visual Ajax Studio
- ModelRight
- TCM - Toolkit for Conceptual Modelling
- Druid III
Resources
PostgreSQL wiki listing supported database design tools - http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
Data Architect
Open System Architect
Power*Architect
dbwrench
Datastudio
xml to DDL
DbDesigner fork
Toad Data Modeler
DeZign for Database
PostgreSQL Maestro
WaveMaker Visual Ajax Studio
ModelRight
TCM - Toolkit for Conceptual Modelling
Druid III