在pgAdmin中创建一个ER图 [英] Create an ER diagram in pgAdmin

问题描述

如何从pgAdmin构建基本的实体关系图将逐步进行?

在pgAdmin中是否有一些插件可以做到这一点?

注意:我在网上搜索，但除了绊倒详尽的软件列表(大多数不是免费软件或过时的软件)外，我在这里没有任何线索.

注2:我的请求没有缩小到pgAdmin，比如说我可以导出表.

解决方案

更新

遗憾的是，数据库设计器毕竟并未随pgAdmin的主发行版一起发布. (至少在1.16到1.22版本中如此).

请参阅讨论此处和最终:

您需要将--enable-databasedesigner与./configure结合使用才能启用 它.默认情况下，它是禁用的.

存在太多的错误和粗糙的边缘，没有足够的人对此进行研究.

---

pgAdmin 在2011年进行了一个GSoC项目，在此过程中，路易斯·奥乔亚(Luis Ochoa)设计了新的数据库设计器-还可以对工程师ER图进行逆向工程".不幸的是，它尚未准备好与pgAdmin 1.14(当前版本)一起发布.但是它可能在版本1.16的存储库中，可能会与PostgreSQL 9.2的发行版一起提供.

在此处观看视频.
截图.
博客发布它.

仍然存在一些粗糙的地方，但是路易斯·奥乔亚(Luis Ochoa)最近宣布他正在对此进行努力.

What would be the step by step walk-through for building a basic Entity-Relationship Diagram from pgAdmin?

Would there be some plugins for doing that in 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.

解决方案

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.)

See discussion here and here and finally:

You need to use --enable-databasedesigner with ./configure to enable it. By default, it's disabled.

There are too many bugs and rough edges and not enough people interested to work on it.

---

pgAdmin had a GSoC project in 2011, in the course of which Luis Ochoa designed the new database designer - which can also reverse engineer ER diagrams from 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.

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.

这篇关于在pgAdmin中创建一个ER图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！