Re: Visualize database schema

From: Wolfgang Keller <feliphil(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Visualize database schema
Date: 2012-08-14 17:14:41
Message-ID: 20120814191441.7e4f280039873542e2f55e88@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

Since this can be automated, it's nice for documentation work.

For inclusion in LaTeX documents, the dot output can then be converted
to TikZ with dot2tex, which is also implemented in Python:

http://www.fauskes.net/code/dot2tex/documentation/

If you're looking for DB modeling tools, here's a pretty comprehensive
list:

http://www.databaseanswers.org/modelling_tools.htm

Sincerely,

Wolfgang Keller

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-08-14 17:19:47 Re: Indexing question
Previous Message amit sehas 2012-08-14 16:54:48 Indexing question