How to get ERD diagram for an existing database

Question

I have a PostgreSQL database  I want to get its ERD  How can I do so

User · Answer

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  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  In the next dialouge box  you ll see that the connection to DBMS is started and schema is revrieved from Database  Go next  Now Select the Schema you created earlier  It is the table you want to create the ER diagram of  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

User · Answer

I use DrawERD for ERD  amp  DB doc  https   drawerd com

User · Answer

postgresql autodoc is a cli for doing this  Doesnt do cardinality  but none of the above mentioned GUI tools do as well

User · Answer

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

User · Answer

You can generate ER diagram from PgAdmin    Open PgAdmin 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  To save go to save as and select Graphical Query  image

User · Answer

The PGADMIN4  version 30  can plot the ERD  Just click on the database with the mouse right-button and then select ERD beta

User · Answer

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

User · Answer

pgModeler can generate nice ER diagram from PostgreSQL databases    https   pgmodeler io  License  GPLv3   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    Click Design button to first create an empty  design model  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  Import all objects  it will warn that you are importing to the current model  which is fine since it is empty   Now switch back to the Design tab to see your ERD

User · Answer

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    Select Tools   DB   Reverse Database    from the toolbar of Visual Paradigm  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   Enter the hostname  database name  user and password  and then click Next  They will then study your database and lists out the tables in it   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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Download DbVisualizer from   https   www dbvis com download 10 0  and after installing create database connection     Change highlighted detail of your db and test by click ping server  Finally click connect  Enjoy

User · Answer

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

[database] How to get ERD diagram for an existing database?

Examples related to database

Examples related to postgresql

Examples related to erd