PostgreSQL schema design [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_StackOverflow社区

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

What is your preferred way of designing PostgreSQL schemata? Would you recommend the use of specific graphical design tools or just design the schema on paper and create everything by hand?

---

I use the Community Edition of MySQL Workbench for creating pretty pictures of my schema - but I'd rather create the DDL that actually runs on my database by hand.

---

You can also try

• OpenModelSphere
• SQL Power Architect

for creating ER diagrams.

For managing the DDL scripts, I have good experience with Liquibase and Power Architect can also create the Liquibase XML directly from the ER diagram.

---

I mostly use paper or sketch the schema directly in psql prompt.

Many UML tools have DDL-generation (see argouml), but in my experience it's faster to write the schema directly. Then you can test it right away.

---

Use only in windows unfortunately, EMS SQL Manager is very good

http://www.sqlmanager.net/products/postgresql/manager

---

pgModeler licensed under GPL, multiplatform.

Binary installer costs 4$, I think it's worth it.