> >> Can anyone advice about a tool to visualize a database schema?
> >
> > SQLalchemy, a Python module, can produce dot (Graphviz) output
> > which you can load into your favourite diagramming application such
> > as e.g. Omnigraffle, yEd or Dia:
> >
> > http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SchemaDisplay
>
> You just made my day -- great stuff. ERD generation should be
> automatic -- whenever I lay them out I feel like I'm fingerpainting.
<hint>
Unlike postgresql_autodoc, which cannot be "embedded" with Pgadmin,
since it is implemented in Perl, which has an embedding-hostile
License as someone once told me, this tiny script could easily be
embedded with Pgadmin, since Python's license is deliberately
embedding-friendly.
And with dot2tex, it would be even possible to generate a complete,
printable, well-typographed PDF documentation of any PostgreSQL database
from within Pgadmin, through LaTeX.
</hint>
Sincerely,
Wolfgang