Re: E-R Tool

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(at)postgresql(dot)org)
----------------------------------------------------------------------
Ray Ontko rayo(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/