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