It's really easy... on the left just open one of your Databases:
Click on Schemas -> Public -> Tables
On Tables right click, and look for "View Diagram"
It also allows you to print your ER diagram and export as an image (png, gif, bmp formats) or as a file in GraphML format. You can check the official DBeaver documentation on ER diagrams here.
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
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.
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.
也许看看 AquaFold 的 Aqua Data Studio。它是一个具有实体关系图表的数据库 IDE。它还包括数据分析。它不是免费的，但考虑到其功能，其价格非常合理。
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.
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)
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.
发布评论
评论（13）
您可以使用 DBeaver 社区 来执行此操作。
这真的很简单......在左侧只需打开一个
数据库：Schemas->公开->TablesTables上右键单击，然后查找“查看图表”它还允许您打印 您的 ER 图并导出为图像（
png、gif、bmp< /code> 格式）或作为GraphML格式的文件。您可以在此处查看关于 ER 图的官方 DBeaver 文档。一个>You can use DBeaver Community to do this.
It's really easy... on the left just open one of your
Databases:Schemas->Public->TablesTablesright click, and look for "View Diagram"It also allows you to print your ER diagram and export as an image (
png,gif,bmpformats) or as a file inGraphMLformat. You can check the official DBeaver documentation on ER diagrams here.pgAdmin 4 版本 30 及更高版本 可以生成 ERD来自现有数据库。只需右键单击数据库并选择生成 ERD。
pgAdmin 4 version 30 and newer can generate the ERD from an existing database. Just right-click on the database and select Generate ERD.
为此，我们使用了 DBVisualizer。
描述：
参考图是一个很棒的功能，因为它会自动呈现所有主要/图形样式的外键映射（也称为引用完整性约束）。表节点和关系会自动布局，并提供多种布局模式。生成的图表是独一无二的，因为它以最佳且可读的布局显示所有信息。
来自其网站
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
pgModeler 可以从 PostgreSQL 数据库生成漂亮的 ER 图。
似乎没有手册，但没有手册也很容易。它是
QT应用程序。 AFAIK，Fedora 和 Ubuntu 都有软件包。 (pgmodeler)
在最新版本的 pgModeler (0.9.1) 中，试用版允许您创建 ERD（设计按钮未禁用）。为此：
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:
从以下位置下载 DbVisualizer：https://www.dbvis.com/download/10.0
并在安装后创建数据库连接：
更改数据库的突出显示详细信息并通过单击 ping 服务器进行测试。最后点击连接
享受。
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.
我们的团队在许多项目中使用 Visual Paradigm 从数据库生成 ER 图。虽然我们主要使用 MS SQL 和 Oracle，但据我所知，它们也支持其他一些 DBMS，如 PostgreSQL、MySQL、Sybase、DB2 和 SQLite。
步骤：
Paradigm
驱动程序并在那里提供驱动程序文件。您只需点击
那里的下载链接可以获取驱动程序。
顺便说一句，它们还支持从 ERD 生成和更新数据库模式。
希望这有帮助。 :-)
有关从 PostgreSQL 数据库生成 ERD 的更多信息
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:
Paradigm
driver and provide the driver file there. You can simply click on
the download link there to get the driver.
BTW they also support generating and updating database schema from ERD.
Hope this helps. :-)
More information about generating ERD from PostgreSQL database
ERBuilder 可以从 PostgreSQL 数据库生成 ER 图（逆向工程功能）。
要生成 ER 图，请按照以下步骤操作：
• 单击“菜单”->“文件->逆向工程
• 单击“新连接”
• 填写PostgresSQL 连接信息
• 单击“确定”
• 单击“下一步”
• 选择要逆向工程的对象（表、触发器、序列……）。
• 单击“下一步”。
自动地。
并从应用程序左侧的树视图中删除表
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.
automatically.
and drop the tables from the treeview placed in the left side of application
另一种选择是使用 Oracle SQL Developer。两个步骤如下：
(1) 首先，您需要将 SQL Developer 连接到您的 PostgreSQL 数据库。
(2) 然后你可以生成一个使用 SQL Developer 的实体关系 (ER) 图
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
postgresql_autodoc是一个用于执行此操作的命令行工具。不做基数，但上面提到的 GUI 工具都不能做基数。postgresql_autodocis a command-line tool for doing this. Doesnt do cardinality, but none of the above mentioned GUI tools do as well.也许看看 AquaFold 的 Aqua Data Studio。它是一个具有实体关系图表的数据库 IDE。它还包括数据分析。它不是免费的，但考虑到其功能，其价格非常合理。
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.
我使用 DrawERD 进行 ERD 和数据库文档。 https://drawerd.com
I use DrawERD for ERD & DB doc. https://drawerd.com
您可以从 PgAdmin 生成 ER 图。
You can generate ER diagram from PgAdmin.
打开 MySQL 工作台。在主屏幕中单击“从现有数据库创建 EER 模型”。我们这样做的情况是，我们已经创建了数据库，现在我们想要创建该数据库的 ER 图。
然后您将看到“反向工程数据库”对话框。如果您被要求输入密码，请提供管理员密码。不要与 Windows 密码混淆。这里您需要提供 MySQL 管理员密码。然后单击“下一步”。
在下一个对话框中，您将看到与 DBMS 的连接已启动，并且模式已从数据库中恢复。继续下一步。
现在选择您之前创建的架构。这是您要为其创建 ER 图的表。
单击“下一步”并转至“选择对象”菜单。在这里，您可以单击“显示过滤器”以使用图表中选定的表对象。您可以在此处添加和删除表。然后单击“执行”。
6.当您转到“下一步”和“完成”时，所需的 ER 图将出现在屏幕上。
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.