Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 45F941337B49 for ; Mon, 15 Nov 2010 13:24:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 88025-03 for ; Mon, 15 Nov 2010 17:24:48 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id CF2981337B56 for ; Mon, 15 Nov 2010 13:24:47 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id oAFHOlfT077893 for ; Mon, 15 Nov 2010 13:24:47 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id oAFH83YP068929 for pgsql-admin@postgresql.org; Mon, 15 Nov 2010 13:08:03 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: GUI ERD/ERM tools? Date: Mon, 15 Nov 2010 11:36:02 -0500 Organization: cbbrowne Computing Inc Lines: 24 Message-ID: <87ipzyfsst.fsf@cbbrowne.afilias-int.info> References: <1842551364.412898.1289572713460.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> <947249383.413123.1289572854503.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) Cancel-Lock: sha1:T2m1dgvCC4GzbqShgbx5pPt4Ynk= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/124 X-Sequence-Number: 36090 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 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. -- 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