database 是否有用于 postgresql 的数据可视化工具，它也能够显示模式间关系？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11839282/
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
Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?
提问by ThinkingMonkey
Operating system used is linux. I have tried Navicatand SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables in a different schema.
使用的操作系统是linux。我试过Navicat和SQL Power Architect。他们确实显示了同一架构中的表之间的关系。我有一些引用不同模式中的表的外键约束。
Am I missing something with respect to Navicat and PostgreSQL Maestro? Can they not display the inter schema relations?
Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?
我是否遗漏了有关 Navicat 和 PostgreSQL Maestro 的内容？他们不能显示模式间关系吗？
是否有用于 postgresql 的数据可视化工具，它也能够显示模式间关系？
UPDSorry for editing your question, but I found it useful. Because this is closed I can not answer (maybe there should be site for that??)
UPD抱歉编辑您的问题，但我发现它很有用。因为这是关闭的我无法回答（也许应该有网站？？）
For drawing table relationship of your database you can try this scriptof GraphViz::DBIperl module.
为了绘制数据库的表关系，您可以尝试使用GraphViz::DBIperl 模块的这个脚本。
As result you will get the GIFwith relations
结果，您将获得带有关系的GIF
回答by cortopy
I've recently discovered DBeaver. It automatically detects relations between tables in a visual manner. You can move tables around, change colors, see foreign keys, etc. It's extremely good. Fully compatible with PostgreSQL
我最近发现了DBeaver。它以视觉方式自动检测表之间的关系。您可以四处移动表格、更改颜色、查看外键等。这非常好。与 PostgreSQL 完全兼容
Querying and manipulating data using the GUI is extremely easy.
使用 GUI 查询和操作数据非常容易。
Not only that you can use it with all major SQL and noSQL databases, so all your data can be managed in just one place.
不仅如此，您可以将它与所有主要的 SQL 和 noSQL 数据库一起使用，因此您的所有数据都可以在一个地方进行管理。
回答by JohnLBevan
DbVisualiser seems to do what you're after: http://www.dbvis.com/doc/main/doc/ug/databaseSpecific/postgresql.html
DbVisualiser 似乎做你所追求的：http: //www.dbvis.com/doc/main/doc/ug/databaseSpecific/postgresql.html
There's also a list of alternate tools here (though it's not as query-able a list as you'd expect from a DB): http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
这里还有一个备用工具列表（尽管它不像您对数据库所期望的那样可查询列表）：http: //wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
