Re: Visualize database schema

From: Johann Spies <jspies(at)sun(dot)ac(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Visualize database schema
Date: 2012-08-16 07:45:10
Message-ID: 20120816074510.GD6863@sun.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 15, 2012 at 01:48:45PM +0200, Wolfgang Keller wrote:
> > >> 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.
>

I could not get the script sqlalchemy_schemadisplay3.py to work with
sqlalchemy 0.7.8-1 (on Debian).

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

I did not know about dot2tex. That opens a new door for using graphviz
with Latex for me. Thanks.

Postgresql-autodoc also generates a .dot file.

I would like to test the sqlalchemy route also.

Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"And whatsoever ye shall ask in my name, that will I
do, that the Father may be glorified in the Son."
John 14:13
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige ls aangeheg by hierdie e-pos nie.

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toby Corkindale 2012-08-16 07:45:18 Re: success with postgresql on beaglebone
Previous Message David Greco 2012-08-15 21:00:32 Re: Set Returning Functions and joins