blocks|key|1171705|text|您可以使用dbeaver来完成此操作。它允许您将ER图导出为png/svg等格式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1171706|DBeaver+-+https://dbeaver.io/|offset|length|1171707|双击一个模式(例如Schemas->public->Tables)并打开"ER+Diagram“选项卡(在"Properties”选项卡旁边)|1171708|entityMap|0|LINK|mutability|MUTABLE|url|https://dbeaver.io/^0|0|A|J|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

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

DBeaver - <a href="https://dbeaver.io/" rel="noreferrer">https://dbeaver.io/</a>

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

blocks|key|1171774|text|从https://www.dbvis.com/download/10.0下载DbVisualizer|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1171775|在安装了create+database+connection之后：|1171776|​|1171777|📷|atomic|1171778|1171779|通过单击ping+server更改数据库和测试的突出显示的详细信息。最后单击connect|1171780|好好享受吧。|1171781|entityMap|0|LINK|mutability|MUTABLE|url|https://www.dbvis.com/download/10.0|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/03bc5680cb4d552c60bc7abb5e54d8ea.png|imageAlt^0|1|Z|0|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|18|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|K|3|G|5|6|7|1D|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1E|8|@]|9|@]|C|$]]|$1|N|3|O|5|6|7|1F|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]]|Q|$R|$5|S|T|U|C|$V|W]]|X|$5|Y|T|Z|C|$10|11|12|-4]]]]

Download DbVisualizer from : <a href="https://www.dbvis.com/download/10.0" rel="noreferrer">https://www.dbvis.com/download/10.0</a>

and after installing create database connection:

<a href="https://i.stack.imgur.com/F3EnF.png" rel="noreferrer"><img src="https://i.stack.imgur.com/F3EnF.png" alt="SS1"></a>

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

Enjoy.

blocks|key|957453|text|我写了这个实用程序，它从postgres数据库自动生成DSL代码，然后您可以将其粘贴到dbdiagram.io/d网站以获得ER图|type|unstyled|depth|inlineStyleRanges|entityRanges|data|957454|https://github.com/nsingla/dbdiagrams|offset|length|957455|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|11|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

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

<a href="https://github.com/nsingla/dbdiagrams" rel="noreferrer">https://github.com/nsingla/dbdiagrams</a>

blocks|key|1171795|text|另一种选择是使用Oracle+SQL+Developer。两个步骤如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1171796|(1)首先，您需要connect+SQL+Developer+to+your+PostgreSQL+database。|1171797|(2)然后你可以generate+an+entity-relationship+(ER)+diagram+using+SQL+Developer|1171798|entityMap|0|LINK|mutability|MUTABLE|url|https://www.oracle.com/database/technologies/appdev/sql-developer.html|1|https://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql|2|https://stackoverflow.com/questions/6580529/how-to-generate-an-entity-relationship-er-diagram-using-oracle-sql-developer^0|8|K|0|0|9|1D|1|0|8|1S|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]]]

Another option is use <a href="https://www.oracle.com/database/technologies/appdev/sql-developer.html" rel="nofollow noreferrer">Oracle SQL Developer</a>. Two steps as below:

(1) First of all, you need to <a href="https://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql">connect SQL Developer to your PostgreSQL database</a>.

(2) Then you can <a href="https://stackoverflow.com/questions/6580529/how-to-generate-an-entity-relationship-er-diagram-using-oracle-sql-developer">generate an entity-relationship (ER) diagram using SQL Developer</a>

blocks|key|1171938|text|我使用DrawERD作为ERD+&+DB文档。https://drawerd.com|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1171939|📷|atomic|1171940|​|1171941|1171942|1171943|1171944|entityMap|0|LINK|mutability|MUTABLE|url|https://drawerd.com/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/dae18dc0b0d541e3ca918bfad24f67e2.jpeg|imageAlt|2|https://ask.qcloudimg.com/http-save/yehe-900000/d30c42792a36c0cdc78ae2d8985a2851.png^0|N|J|0|0|0|1|1|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|C|$]]|$1|I|3|H|5|6|7|1A|8|@]|9|@]|C|$]]|$1|J|3|E|5|F|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|K|3|H|5|6|7|1F|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|U|P|V|C|$W|X|Y|-4]]|Z|$5|U|P|V|C|$W|10|Y|-4]]]]

I use DrawERD for ERD &amp; DB doc. <a href="https://drawerd.com" rel="nofollow noreferrer">https://drawerd.com</a>
<a href="https://i.stack.imgur.com/yHWOa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yHWOa.jpg" alt="enter image description here" /></a>
<a href="https://i.stack.imgur.com/njo03.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/njo03.png" alt="enter image description here" /></a>

blocks|key|1171816|text|也许你可以看看AquaFold的Aqua+Data+Studio。它是一个带有实体关系图的数据库IDE。它还包括数据分析。它不是免费的，但考虑到它的性能，它的价格是非常合理的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1171817|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|957587|text|postgresql_autodoc就是这样做的cli。不做基数，但是上面提到的GUI工具都不能做的很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|957588|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

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

How to get ERD diagram for an existing database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我有一个PostgreSQL数据库。我要拿到它的急诊室。我如何做到这一点呢？

问如何获取现有数据库的ERD图？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取现有数据库的ERD图？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取现有数据库的ERD图？
EN