Em 14/08/2012 15:47, Scott Mead escreveu:


On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö <robert.grav...@imano.se <mailto:robert.grav...@imano.se>> wrote:


    > 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).

    A simple method for this, open source cross-platform and work for
    various RDBMS, is the following:
     1. Download  SQL Power Architect at
    https://code.google.com/p/power-architect/downloads/list (it's a
    java app so you need a JVM installed and JDBC drivers for the
    RDBMS to use)


+1 on SQL Power Architect.  I use it a lot.

--Scott

I like SQL Power Architect, but IMHO it has a big flaw: you can't create separate tables in several (logical) diagrams, you can have only one big diagram for entire database (please, correct me if I'm wrong!).

At this point, I do prefer DbWrench (besides it is not free, it's cheap and works fairly well - but support is weak).

Regards,

Edson

    2. Run it, right click in left pane and choose "Add source
    connection" -> "New connection..." to create a connection for your db
    3. Expand the connection  and the database and then simply drag
    and drop the schema to the right pane.
    4. Click on "Automatic layout" in the toolbar (it's the icon that
    looks like three connected boxes and a green triangle)

    >From there you can examine the database. There are some
    limitations, constraints for example, so for more complicated tools
    look into ERD-tools as suggested by John in another reply.

    Regards,
    roppert


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



Reply via email to