Re: GUI ERD/ERM tools?

Another option is 'Database => Reverse Engineer' in Visio.

Sam

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Chris Browne
Sent: Tuesday, 16 November 2010 3:06 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] GUI ERD/ERM tools?

loupicciano(at)comcast(dot)net (Lou Picciano) writes:
> This question from our users keeps coming up...
>
> What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder
> is helpful, but doesn't address the need.
>
> Can any of you recommend specific tools, preferences, etc?

I have tended to find that when doing design work, nothing is better for
the purposes of discussion of alternatives than a whiteboard and
markers.

Once the thinking has been done, I might use TCM to draft diagrams of
some of the relationships <http://wwwhome.cs.utwente.nl/~tcm/> to
compactly present them.

Once the thinking is stable enough to create tables, I like SchemaSpy
for providing diagramming that people can "click through" to examine the
relationships between tables. <http://schemaspy.sourceforge.net/>
--
output = ("cbbrowne" "@" "gmail.com")
"Implying that you can build systems without rigourous interface
specification is always a powerful selling technique to the clueless."
-- Paul Campbell, seen in comp.object.corba