From: | Dann Corbit <DCorbit(at)connx(dot)com> |
---|---|
To: | 'Dario Beraldi' <dario(dot)beraldi(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Visualize database schema |
Date: | 2012-08-14 16:21:09 |
Message-ID: | 87F42982BF2B434F831FCEF4C45FC33E55A624F9@EXCHANGE.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is nice:
http://sourceforge.net/projects/mogwai/?source=directory
The install is fiddly, and the interface is JDBC. But it does a very good job of reverse engineering a schema and graphically displaying it.
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Dario Beraldi
Sent: Tuesday, August 14, 2012 1:55 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Visualize database schema
Hello,
Apologies if this question has been asked before, but I couldn't come up with a decent solution...
Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and produces a graphical representation of the tables, constraints and indexes which can be moved around for ease of visualization (something like the "Graphical query builder" that comes with pgAdmin =>1.14).
I don't care (and don't want) to modify or query the database with such tool, I just want to visualize it. (In fact, I tried to use pgAdmin for this but the graphical queries can only be saved as images and so they cannot be reloaded).
Thanks!
Dario
From | Date | Subject | |
---|---|---|---|
Next Message | amit sehas | 2012-08-14 16:54:48 | Indexing question |
Previous Message | Bruce Momjian | 2012-08-14 15:44:34 | Re: Regarding pc-lint on PostgreSQL code |