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?

2 Answers 2


I don't think there is one for PG (though I think that pgAdmin will have something like this in the future).

If I need visualization of PostgreSQL data schema, I use the MySQL Workbench (I know, I wil burn in hell for this...). This works pretty good, though i throws some errors with SQL not known to MySQL (though this does not stop the process on the first error, it continues). This worked pretty well for me in the past.

Be warned though: many of the features only work with MySQL somewhere in the back or SQL generated by/for MySQL. This is only usefull if you want plain visualization.


I think Postgresql Autodoc can help you. In case you use Debian or Ubuntu, it is packaged under the name postgresql-autodoc.

  • The link doesn't work anymore...
    – DrColossos
    Oct 20, 2014 at 12:41
  • @DrColossos: I put the link to the PgFoundry page for the project. Nov 5, 2014 at 9:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.