PostgreSQL schema design

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?

You should try GenMyModel (https://www.genmymodel.com) it supports online database design. — Xaelis, Feb 11 '15 at 07:09

score 3 · Answer 1 · answered Mar 28 '11 at 12:28

3

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.

answered Mar 28 '11 at 12:28

score 2 · Accepted Answer · answered Mar 28 '11 at 12:36

You can also try

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.

score 1 · Answer 3 · answered May 02 '14 at 17:56

1

pgModeler licensed under GPL, multiplatform.

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

answered May 02 '14 at 17:56

Kerb

1,138
2
20
39

This looks very promising; it's quite new isn't it? – akosch May 05 '14 at 12:09
Perhaps this is an old thread, but I checked the Mac installer and it's closer to $120 in 2019 – blueether Oct 30 '19 at 21:36

score 1 · Answer 4 · answered Mar 28 '11 at 15:21

1

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.

answered Mar 28 '11 at 15:21

jkj

2,561
1
17
24

score 1 · Answer 5 · answered Mar 28 '11 at 15:35

1

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

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

answered Mar 28 '11 at 15:35

PostgreSQL schema design

5 Answers5