I recommend Clay (http://www.azzurri.jp/en/software/clay/index.jsp)
It requires a JRE + Eclipse (as it is an eclipse plugin), but it is really nice to work with and has built-in support for PostgreSQL DDL generation.
/Mikael