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

database postgresql database-design entity-relationship postgresql-9.1
ThinkingMonkey picture ThinkingMonkey · Aug 7, 2012 · Viewed 34k times · Source

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

Answer

cortopy picture cortopy · Dec 8, 2015

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

Querying and manipulating data using the GUI is extremely easy.

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.

Related questions

PostgreSQL: Is it better to use multiple databases with one schema each, or one database with multiple schemas?

After this comment to one of my question, I'm thinking if it is better using one database with X schemas or vice versa. My situation: I'm developing a web application where, when people register, I create (actually) a database (no, …

Read More
How to implement a many-to-many relationship in PostgreSQL?

I believe the title is self-explanatory. How do you create the table structure in PostgreSQL to make a many-to-many relationship. My example: Product(name, price); Bill(name, date, Products);

Read More
Use email address as primary key?

Is email address a bad candidate for primary when compared to auto incrementing numbers? Our web application needs the email address to be unique in the system. So, I thought of using email address as primary key. However my colleague …

Read More