Another option is 'Database => Reverse Engineer' in Visio.
Sam
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Browne
Sent: Tuesday, 16 November 2010 3:06 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] GUI ERD/ERM tools?
loupicciano@comcast.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin