From: | Wolfgang Keller <feliphil(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Visualize database schema |
Date: | 2012-08-15 11:48:45 |
Message-ID: | 20120815134845.fc79968e3c1a9393465eae12@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> >> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Amitabh Kant | 2012-08-15 13:19:13 | Re: corrupted statistics file "pg_stat_tmp/pgstat.stat" |
Previous Message | Andrew Hastie | 2012-08-15 10:45:21 | PG Installer - Licensing Issues |