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 [EMAIL PROTECTED]) ---------------------------------------------------------------------- Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
