Re: Tool for data modeling and ER diagram

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tool for data modeling and ER diagram
Date: 2010-12-07 19:40:54
Message-ID: 87k4jl5q2h.fsf@cbbrowne.afilias-int.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

gwchamb(at)gmail(dot)com (Gary Chambers) writes:
>> What is the best tool of data modeling and ER diagram for PostgreSQL.
>> http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
>
> Although it may not be considered a tool for use in the design (per
> se) of a database, I would highly recommend that SchemaSpy
> (http://schemaspy.sourceforge.net/) be added to the list.

I have added TCM to the list...
http://wwwhome.cs.utwente.nl/~tcm/

I use it quite a lot when designing things. It makes no attempt to do
automagic mapping of diagrams onto physical implementation, but when
trying to deal with reasonably deep modelling issues (e.g. - trying to
figure out what are the entities and what are the relationships between
them), the full detail of schemas of tables seem like a distraction.
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/slony.html
Rules of the Evil Overlord #2. "My ventilation ducts will be too small
to crawl through. <http://www.eviloverlord.com/>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gurjeet Singh 2010-12-07 19:53:25 Re: Do we want SYNONYMS?
Previous Message Joshua D. Drake 2010-12-07 19:24:36 Re: Do we want SYNONYMS?