Generate the ERD for an existing database

DatabasePostgresqlErd

Database Problem Overview

I have a PostgreSQL database. I want to generate ERD from that database. Are there any built-in tools to do it or maybe some third-party tools?

Database Solutions

Solution 1 - Database

You can use dbeaver to do this. It allows you to export the ER diagram as png/svg etc.

DBeaver - https://dbeaver.io/

Double click on a schema (eg, Schemas->public->Tables) and open the "ER Diagram" tab (next to "Properties" tab)

Solution 2 - Database

pgAdmin 4 version 30 and newer can generate the ERD from an existing database. Just right-click on the database and select Generate ERD (Beta).

Right click and generate ERD

Solution 3 - Database

We used DBVisualizer for that.

Description: The references graph is a great feature as it automatically renders all primary/foreign key mappings (also called referential integrity constraints) in a graph style. The table nodes and relations are layed out automatically, with a number of layout modes available. The resulting graph is unique as it displays all information in an optimal and readable layout. from its site

Solution 4 - Database

pgModeler can generate nice ER diagram from PostgreSQL databases.

It seems there is no manual, but it is easy enough without manual. It's QT application. AFAIK, Fedora and Ubuntu has package. (pgmodeler)

In the latest version of pgModeler (0.9.1) the trial version allows you to create ERD (the design button is not disabled). To do so:

  1. Click Design button to first create an empty 'design model'
  2. Then click on Import and connect to the server and database you want (unless you already set that up in Manage, in which case all your databases will be available to select in step 3)
  3. Import all objects (it will warn that you are importing to the current model, which is fine since it is empty).
  4. Now switch back to the Design tab to see your ERD.

Solution 5 - Database

Download DbVisualizer from : https://www.dbvis.com/download/10.0

and after installing create database connection:

SS1

Change highlighted detail of your db and test by click ping server. Finally click connect

Enjoy.

Solution 6 - Database

I wrote this utility, it automatically generates the DSL code from a postgres database which you can then paste into dbdiagram.io/d website to get ER diagrams

https://github.com/nsingla/dbdiagrams

Solution 7 - Database

Our team use Visual Paradigm to generate ER diagram from database in many of our projects. While we mainly work on MS SQL and Oracle, as I know they also support some other DBMS like PostgreSQL, MySQL, Sybase, DB2 and SQLite.

Steps:

  1. Select Tools > DB > Reverse Database... from the toolbar of Visual Paradigm
  2. Keep the settings as is and click Next Select PostgreSQL as driver and provide the driver file there. You can simply click on the download link there to get the driver.
  3. Enter the hostname, database name, user and password, and then click Next
  4. They will then study your database and lists out the tables in it.
  5. Select the table to form an ERD and continue, and that's it. An ERD will be generated with the tables you selected presented.

BTW they also support generating and updating database schema from ERD.

Hope this helps. :-)

More information about generating ERD from PostgreSQL database

Solution 8 - Database

ERBuilder can generate ER diagram from PostgreSQL databases (reverse engineer feature).

Below step to follow to generate an ER diagram:

• Click on Menu -> File -> reverse engineer

• Click on new connection

• Fill in PostgresSQL connection information

• Click on OK

• Click on next

• Select objects (tables, triggers, sequences…..) that you want to reverse engineer.

• Click on next.

  • If you are using trial version, your ERD will be displayed automatically.
  • If your are using the free edition you need to drag and drop the tables from the treeview placed in the left side of application

enter image description here

Solution 9 - Database

Another option is use Oracle SQL Developer. Two steps as below:

(1) First of all, you need to connect SQL Developer to your PostgreSQL database.

(2) Then you can generate an entity-relationship (ER) diagram using SQL Developer

Solution 10 - Database

I use DrawERD for ERD & DB doc. https://drawerd.com enter image description here

enter image description here

Solution 11 - Database

Perhaps have a look at AquaFold's Aqua Data Studio. It is a database IDE with entity-relationship diagramming. It also includes data profiling. It is not free but its price is very reasonable considering its capabilities.

Solution 12 - Database

postgresql_autodoc is a cli for doing this. Doesnt do cardinality, but none of the above mentioned GUI tools do as well.

Solution 13 - Database

You can generate ER diagram from PgAdmin.

  1. Open PgAdmin

  2. Right click on any table and select statement and it will show two window one is query other is graphical window so you can add the table which you want to generate the diagram.

  3. To save go to save as and select Graphical Query (image)

Solution 14 - Database

  1. Open MySQL Workbench. In the home screen click 'Create EER Model From Existing Database'. We are doing this for the case that we have already made the data base and now we want to make an ER diagram of that database.

  2. Then you will see the 'Reverse Engineer Database' dialouge. Here if you are asked for the password, provided the admin password. Do not get confused here with the windows password. Here you need to provide the MySQL admin password. Then click on Next.

  3. In the next dialouge box, you'll see that the connection to DBMS is started and schema is revrieved from Database. Go next.

  4. Now Select the Schema you created earlier. It is the table you want to create the ER diagram of.

  5. Click Next and go to Select Objects menu. Here you can click on 'Show Filter' to use the selected Table Objects in the diagram. You can both add and remove tables here.Then click on Execute.

6.When you go Next and Finish, the required ER diagram is on the screen.

Categories
Recommended Database Solutions
Recommended Postgresql Solutions
Recommended Erd Solutions

Previous Solution:

How to exit from the application and show the home screen?

AndroidExitBack Button

Next Solution:

What is wrong with using goto?

C++Goto

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionBadrView Question on Stackoverflow
Solution 1 - DatabasekrishnakumarpView Answer on Stackoverflow
Solution 2 - DatabaseAbdinardo OliveiraView Answer on Stackoverflow
Solution 3 - Databaserudi-mooreView Answer on Stackoverflow
Solution 4 - DatabaseYasuo OhgakiView Answer on Stackoverflow
Solution 5 - DatabaseankitView Answer on Stackoverflow
Solution 6 - Databasens12345View Answer on Stackoverflow
Solution 7 - DatabaseKyle CostelloView Answer on Stackoverflow
Solution 8 - Databasefeliciano popovView Answer on Stackoverflow
Solution 9 - DatabaseYuciView Answer on Stackoverflow
Solution 10 - DatabaseHooopoView Answer on Stackoverflow
Solution 11 - DatabasedbexpertView Answer on Stackoverflow
Solution 12 - DatabaseJoost HelbergView Answer on Stackoverflow
Solution 13 - DatabaseHusenView Answer on Stackoverflow
Solution 14 - DatabasesujithView Answer on Stackoverflow