How to get a DataBase Design for POSTGRESQL to create a ER-Diagram?

09Q71AO534 picture 09Q71AO534 · Oct 14, 2013 · Viewed 9.3k times · Source

I am using postgresql 9.2

postgres=# select version();
                           version
-------------------------------------------------------------
 PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit
(1 row)

and pgadmin III

I have a database with tables which have one-to-many & many-to-one relationships.

I want to make ER diagrams, i.e., a database design of the tables.

I have searched and referred to this question but I am unable to understand what I should do to get the database design installed into my pgadmin III as shown in the video of the link, i.e., the image view.

I'm confused whether to make any installations, or is it like an Addon? I'm confused about what to do.

I need some support on how to make this work so that I can make an ER-diagram by using pgadmin III.

Answer

William Wino picture William Wino · Oct 23, 2013

I don't know how to get that button to appear. But I've read the Community Guide to PostgreSQL GUI Tools and found this Valentina. Which supports forward/reverse engineering for PostgreSQL database. You can also try the similar products from the same page.

Alternatively you can try this SchemaSpy, here is an example of the output. Note that higher level / raw ERD is impossible to be auto-generated as it is a subject of many different interpretations.

Here is a commercial alternative software to achieve a similar result: DbVis.