6

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.

Community
  • 1
  • 1
09Q71AO534
  • 4,300
  • 13
  • 44
  • 68
  • I haven't used pgadmin in ages, but back then the diagram functionality was built-in. Perhaps it has moved or something like that? Did you try all of the various buttons, check the manual, etc.? – Denis de Bernardy Oct 22 '13 at 12:22
  • @Denis I checked the [Community Guide for PostgreSQL GUI](http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools) but i am unable to find that. – 09Q71AO534 Nov 08 '13 at 05:54
  • I will sure check SchemaSpy :) Thanks for your suggestion @kmonsoor – 09Q71AO534 Dec 19 '14 at 05:41
  • 2
    you may try [SchemaSpy](http://schemaspy.sourceforge.net/). I have posted [a step-by-step guide for it](http://blog.kmonsoor.com/generate-er-diagram-from-sql-database/). SchemaSpy worth the shot. – kmonsoor Dec 01 '15 at 21:55

1 Answers1

7

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.

William Wino
  • 3,599
  • 7
  • 38
  • 61
  • 2
    As of May 2014 this is a great solution and even appears to beat pgAdmin3 on many fronts. – smcjones May 29 '14 at 00:05
  • 1
    The folks from Valentina can't even spell PostgreSQL correctly - they use "Postgre" on their homepage. That sounds as if they don't really use Postgres that much. –  Jan 09 '15 at 12:57