Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B531D1337E15 for ; Fri, 12 Nov 2010 12:42:33 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 82175-02-8 for ; Fri, 12 Nov 2010 16:42:25 +0000 (UTC) X-Greylist: delayed 00:23:46.205807 by SQLgrey-1.7.6 Received: from mail-gx0-f174.google.com (mail-gx0-f174.google.com [209.85.161.174]) by mail.postgresql.org (Postfix) with ESMTP id B2D9B1337C68 for ; Fri, 12 Nov 2010 12:31:19 -0400 (AST) Received: by gxk23 with SMTP id 23so1938562gxk.19 for ; Fri, 12 Nov 2010 08:31:18 -0800 (PST) Received: by 10.42.241.1 with SMTP id lc1mr2512196icb.259.1289578046261; Fri, 12 Nov 2010 08:07:26 -0800 (PST) Received: from tech304 (supranet-tech.secure-on.net [66.170.8.18]) by mx.google.com with ESMTPS id fw4sm3800870ibb.19.2010.11.12.08.07.24 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 12 Nov 2010 08:07:25 -0800 (PST) Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes To: pgsql-admin , "Lou Picciano" Subject: Re: GUI ERD/ERM tools? References: <947249383.413123.1289572854503.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Date: Fri, 12 Nov 2010 10:07:23 -0600 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Mark Felder" Message-ID: In-Reply-To: <947249383.413123.1289572854503.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> User-Agent: Opera Mail/11.00 (FreeBSD) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/97 X-Sequence-Number: 36063 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