PostgreSQL extension developed by Adrian Andrei is available in Extension Registry. It allows you to generate DDL from ERD model to PostgreSQL DDL. This extension is open source and hosted on Github (https://github.com/adrianandrei-ca/staruml-postgresql). Thanks to Adrian.