Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well? [closed]
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.
DbVisualiser seems to do what you're after: http://www.dbvis.com/doc/main/doc/ug/databaseSpecific/postgresql.html
There's also a list of alternate tools here (though it's not as query-able a list as you'd expect from a DB):http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools