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