I don't know of any good open source ones. There's Dia, but it's basically for documentation purposes only.
The proprietary one I know of (besides the popular ERwin and PowerDesigner) is DataArchitect, from thekompany.com, and they support PostgreSQL very heavily.