Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?

Viewed 41616

Operating system used is linux. I have tried Navicat and 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.

  • 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?

UPD Sorry for editing your question, but I found it useful. Because this is closed I can not answer (maybe there should be site for that??)

For drawing table relationship of your database you can try this script of GraphViz::DBI perl module.

As result you will get the GIF with relations

2 Answers
Related