用Postgresql生成数据库表图的工具? [英] Tools to generate database tables diagram with Postgresql?
问题描述
有没有免费的工具可以用Postgresql生成表图?
Are there any free tools to generate tables diagrams with Postgresql?
推荐答案
我爱 schemaspy 进行模式可视化。查看他们提供的样本输出,然后流口水。注意选项卡!
I love schemaspy for schema visualisations. Look at the sample output they provide, and drool. Note the tabs!
您需要下载此处的JDBC驱动程序,那么您的命令应类似于:
You'll need to download the JDBC driver here, then your command should look something like:
java -jar schemaspy-6.0.0-rc2.jar -t pgsql -db database_name -host myhost -u username -p password -o ./schemaspy -dp postgresql-9.3-1100.jdbc3.jar -s public -noads
有时,如果您的数据库具有不同的端口,则使用选项 -port
将不起作用,因此您必须在主机参数后添加手动端口,例如:
Sometimes using options -port
will not working if your database has diferrent port, so you have to add manual port after host parameter, for example:
java -jar schemaspy-6.0.0-rc2.jar -t pgsql -db database_name -host myhost:myport -u username -p password -o ./schemaspy -dp postgresql-9.3-1100.jdbc3.jar -s public -noads
如果需要图形,还需要安装 graphviz
( apt-get install graphviz
(用于基于Debian的发行版)。
You'll need to install graphviz
as well if you want graphics (apt-get install graphviz
for debian based distros).
这篇关于用Postgresql生成数据库表图的工具?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!