X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AB40DD1B3AD for ; Mon, 7 Jun 2004 19:05:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64576-03 for ; Mon, 7 Jun 2004 22:05:24 +0000 (GMT) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by svr1.postgresql.org (Postfix) with ESMTP id 74D43D1B345 for ; Mon, 7 Jun 2004 19:05:18 -0300 (ADT) Received: from shire.ontko.com (rayo@localhost [127.0.0.1]) by shire.ontko.com (8.12.3/8.12.3/Debian-6.6) with ESMTP id i57M5Krr031693; Mon, 7 Jun 2004 17:05:20 -0500 Received: (from rayo@localhost) by shire.ontko.com (8.12.3/8.12.3/Debian-6.6) id i57M5K1v031691; Mon, 7 Jun 2004 17:05:20 -0500 From: Ray Ontko Date: Mon, 7 Jun 2004 17:05:20 -0500 To: Renney Thomas Cc: pgsql-admin@postgresql.org Subject: Re: E-R Tool Message-ID: <20040607220520.GT23845@ontko.com> References: <20040531211523.46183.qmail@web14101.mail.yahoo.com> <40BC7107.2040703@trade-india.com> <40C164A6.80708@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40C164A6.80708@yahoo.com> User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/83 X-Sequence-Number: 13743 Renney, We've recently begun using Mogwai: http://mogwai.sourceforge.net/erdesigner/erdesigner.html It's a lot like ERwin, but is open source and written in Java, so it runs almost anywhere. We run it under Windows and Linux. I assume that it will reverse engineer any foreign key constraints that are defined in postgresql. In our application, we don't enforce the constraints so we didn't pick these up from the database. Instead, we drew the relationship lines between the entities after picking up the tables from postrgresql. It figured out the crows-feet part from there. Hope this helps. Ray On Sat, Jun 05, 2004 at 02:13:58AM -0400, Renney Thomas wrote: > Can someone suggest an E-R tool that will read a _PG_ database and > create an E-R diagram - crows feet and all? Are there any that are > available for free? > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ---------------------------------------------------------------------- Ray Ontko rayo@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/