pgModeler is an open source tool for modeling PostgreSQL databases which is very similar to MySQL Workbench. The models created by the user can be exported to SQL code and applied directly into database clusters (Version 9.x). As a Workbench user, it took me only couple of minutes to design my first PostgreSQL database model.
The link: http://www.pgmodeler.com.br/