Good schema design tools are the missing piece for making PostgreSQL the complete package. Ideally there'd be an officially supported tool that allowed you to

Good schema design tools are the missing piece for making PostgreSQL the complete package. Ideally there'd be an officially supported tool that allowed you to define your relationships at a high level and it would create a well normalised and indexed schema for you automatically.