GUI Database Design Tools

From PostgreSQL wiki

If you're building a complicated data model, support from tools that provide for the creation of Entity-Relationship diagrams and similar techniques are extremely useful. Some tools that have been suggested as useful by the PostgreSQL community are:

• Data Architect
• Open System Architect
• Power*Architect
• dbwrench
• Datastudio
• xml to DDL
• DbDesigner fork
• Toad Data Modeler
• DbSchema
• DeZign for Database
• PostgreSQL Maestro
• WaveMaker Visual Ajax Studio
• ModelRight
• TCM - Toolkit for Conceptual Modelling
• Druid III
• Moskitt and its spatial plugin for PostGIS users
• PGmodeler

Also, pgadmin3 isn't a serious design tool, but can be helpful for browsing and simple additions