You can use MicroOLAP Database Designer for PostgreSQL software/tool to develop, design, model, and modify databases for postgresql.
MicroOLAP Database Designer for PostgreSQL is a visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way. It not only accelerates and makes the process of database creation clear but also simplifies database maintenance. MicroOLAP Database Designer for PostgreSQL is specially developed for popular PostgreSQL database and takes into account its features.