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.
As a Postgres ER diagram tool, Navicat has the essential features for modeling your conceptual, logical, and physical data models. You can create complex ER Diagrams in Navicat using one of three standard notations: Crow's Foot, UML, or IDEF1x.
You can also import your own database to streamline ERD creation. LucidChart has plenty of collaboration options so you can work on the diagram with your teammates collectively (with features like sticky notes, comments, and mentions).
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With