Re: Visualize database schema

[Sébastien Lorion <sl@xxxxxxxxxxxxxxxxxxxxx>]

Concerning auto-layout, most if not all tools I have used up to now make a mess for anything that is not dead simple. One exception I found is Embarcadero Data Architect (http://www.embarcadero.com/products/er-studio-data-architect). It's not free, but there is a trial you can use and then you can export models as pdf or w/e.

Sébastien

On Tue, Aug 14, 2012 at 11:07 AM, Zdeněk Bělehrádek <zdenek.belehradek@xxxxxxxxxxxxxxx> wrote:

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

I am using SchemaSpy (http://schemaspy.sourceforge.net/) from time to time. It connects to running database (using JDBC driver, so it can talk to practically any RDBMS) and generates set of HTML pages containing interlinked diagrams and descriptions of schema. It can even guess relations from column names.

With regards
Zdeněk Bělehrádek

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general