Re: Visualize database schema

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

In response to

Browse pgsql-general by date

  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