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.belehra...@superhosting.cz> 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/<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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >