Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer

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

share|improve this answer
The link doesn't work anymore... – DrColossos Oct 20 '14 at 12:41
@DrColossos: I put the link to the PgFoundry page for the project. – Éric Guirbal Nov 5 '14 at 9:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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