Create an ER diagram or any DB diagram with tables already existing in postgresql

Question

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

Possible duplicate of [How to get ERD diagram for an existing database?](https://stackoverflow.com/questions/3474389/how-to-get-erd-diagram-for-an-existing-database) — Peter Šály, Mar 26 '19 at 18:32

score 1 · Answer 1 · answered Mar 26 '19 at 14:33

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

answered Mar 26 '19 at 14:33

Kamil W

2,230
2
21
43

Remember that I want from entity to table, not table to entity – StuartDTO Mar 26 '19 at 14:33
Ahhh... sorry I thought you want to do it in reverse, I think JPA can generate your database schema after that you can make sql dump of your database. – Kamil W Mar 26 '19 at 14:37
How can I do it @Kamil W? – StuartDTO Mar 26 '19 at 14:38

score 1 · Answer 2 · answered Mar 26 '19 at 14:41

1

You can simply create the tables in an empty schema and then run DB Visualizer on it.

answered Mar 26 '19 at 14:41

fhossfel

2,041
16
24

score 1 · Accepted Answer · answered Mar 26 '19 at 14:42

1

Navicat's Data Modeler tool might do what you want. They have a free trial.

https://www.navicat.com/en/products/navicat-data-modeler

answered Mar 26 '19 at 14:42

mmccaff

1,281
1
11
20

score 1 · Answer 4 · answered Feb 23 '22 at 17:53

1

Using pgAdmin 4 you can right click on database and choose option Generate ERD.

answered Feb 23 '22 at 17:53

santal

55
5

Create an ER diagram or any DB diagram with tables already existing in postgresql

4 Answers4