Hi folks,

I am trying to make regular ERD's of a changing PostgreSQL DB
available to developers at my organization.

Two questions:

1. Is there a good product available to Mac OSX that can reverse
engineer preexisting PostgreSQL DB's? So far I've had the best luck
using Visio on Windows, but I primarily work on the Mac OSX and would
prefer not to lug out to the Windows machine just for this task.

2. Is there a good way to automate this process? I want to make ERD's
or make notes of changes weekly.

Thanks --

Hi,

You could give "Mogwai ERDesignerNG" a try. It is Open Source and allows
either to store the model graphically (.png, .svg) or as XML.
It is also available as Netbeans-Plugin.

http://sourceforge.net/projects/mogwai/

You could easyly extend the existing application yourself or file a
feature-request to support commandline options on
http://sourceforge.net/tracker/?atid...84&func=browse.

Then the desired automation would be possible.

HTH