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