'Create an ER diagram or any DB diagram with tables already existing in postgresql
I'm trying to do a reverse engineering, I mean instead of from ER diagram get the tables, the opposite way, from the tables and the JPA done, do the db diagram, is it possible?
I'm using PostgreSQL, Postico2 and InteliJ for Jpa/Hibernate
I've found this Jeddict but I guess it's not what I'm looking for.
ACLARIMENT : I want from ENTITY to TABLE (Diagram) or from Postico 2 where I see all of the tables to Diagram
Solution 1:[1]
The one way to do that which I met is to use eclipse plugin called Hibernate Tools which allows to do it. Please take a look at these references:
Generating entities from tables
Using Hibernate Tools generate entity classes from Tables
Solution 2:[2]
You can simply create the tables in an empty schema and then run DB Visualizer on it.
Solution 3:[3]
Using pgAdmin 4 you can right click on database and choose option Generate ERD.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Kamil W |
| Solution 2 | fhossfel |
| Solution 3 | snatal |
