Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 45A43133798E for ; Fri, 12 Nov 2010 14:48:26 -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 45587-09 for ; Fri, 12 Nov 2010 18:48:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailgate.iii.com (mailgate.iii.com [205.227.88.3]) by mail.postgresql.org (Postfix) with ESMTP id A46701336971 for ; Fri, 12 Nov 2010 14:48:18 -0400 (AST) Received: from mailhub.iii.com (mailhub [10.1.2.3]) by mailgate.iii.com (8.13.6/8.13.6) with ESMTP id oACIes6u032460 for ; Fri, 12 Nov 2010 10:40:54 -0800 (PST) Received: from [10.1.7.210] ([10.1.7.210]) by mailhub.iii.com (8.13.6/8.13.6) with ESMTP id oACIpGP6012167 for ; Fri, 12 Nov 2010 10:51:16 -0800 (PST) Message-ID: <4CDD8BF8.5060902@iii.com> Date: Fri, 12 Nov 2010 10:48:24 -0800 From: Dinesh Bhandary Reply-To: dbhandary@iii.com Organization: Innovative Interfaces User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: GUI ERD/ERM tools? References: <947249383.413123.1289572854503.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/103 X-Sequence-Number: 36069 I've used eclipse with clay ( plugin) in the past, it is pretty good. And it is free,. Dinesh On 11/12/2010 8:07 AM, Mark Felder wrote: > On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano > wrote: > >> >> What tools are each of you using for ERD ERM? pgAmin's Graphical >> Query Builder is helpful, but doesn't address the need. > > I'm not a database guru and I'm not 100% clear on "ERD ERM", but I > will try to help anyway :) > > I used to work at an Oracle-heavy shop and the preference for the DBAs > and developers was a tool called TOAD. You can find this software at > http://toadworld.com/. It doesn't seem to be well known outside of the > Oracle circles, but if their support for Postgres is half as good as > their support for Oracle I think you would find it to be an amazing > tool for visualizing the database, building queries, etc. > > Good luck! > > > Regards, > > > Mark >