SQL 在 pgAdmin 中创建 ER 图
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9692913/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Create an ER diagram in pgAdmin
提问by vdegenne
What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin?
从 pgAdmin 构建基本实体关系图的分步演练是什么？
Would there be some plugins for doing that in pgAdmin?
在 pgAdmin 中是否有一些插件可以做到这一点？
Note: I searched in the web but other than stumbling upon an exhausting list of softwares (most of them not freeware or out-of-date) I wind up here without a clue.
注意：我在网络上进行了搜索，但除了偶然发现令人筋疲力尽的软件列表（其中大多数不是免费软件或过时的）之外，我一无所获。
Note2: My request is not narrowed down to pgAdmin, let's say I can export my tables.
注2：我的请求没有缩小到 pgAdmin，假设我可以导出我的表。
采纳答案by Erwin Brandstetter
Update
更新
Sadly, the database designer is not released with the main release of pgAdmin after all.(At least the case for version 1.16 through 1.22.)
遗憾的是，数据库设计器毕竟没有随 pgAdmin 的主要版本一起发布。（至少版本 1.16 到 1.22 的情况是这样。）
See discussion hereand hereand finally:
You need to use
--enable-databasedesignerwith./configureto enable it. By default, it's disabled.
您需要使用
--enable-databasedesignerwith./configure来启用它。默认情况下，它是禁用的。
There are too many bugs and rough edges and not enough people interested to work on it.
有太多的错误和粗糙的边缘，没有足够的人有兴趣去研究它。
pgAdminhad a GSoC project in 2011, in the course of which Luis Ochoa designed the new database designer- which can also reverse engineer ER diagramsfrom existing dbs. Unfortunately it wasn't ready for release with pgAdmin 1.14 (the current version). But it's in the repository for version 1.16 that will probably accompany the release of PostgreSQL 9.2.
pgAdmin在 2011 年有一个 GSoC 项目，在此过程中 Luis Ochoa 设计了新的数据库设计器——它也可以从现有的 dbs逆向工程 ER 图。不幸的是，它还没有准备好与 pgAdmin 1.14（当前版本）一起发布。但它在 1.16 版本的存储库中，可能会伴随 PostgreSQL 9.2 的发布。
See a video here.
Screenshot.
Blog post announcing it.
There are still some rough edges, but Luis Ochoa recently announced he is working on it.
仍有一些粗糙的边缘，但路易斯奥乔亚最近宣布他正在努力。
回答by tmikulcek
If you are running Linux, you could use pgDesigner: http://sourceforge.net/projects/pgdesigner/
如果您运行的是 Linux，则可以使用 pgDesigner：http: //sourceforge.net/projects/pgdesigner/
