Re: Reverse engineering PG database

Thanks.

We are alreaady using Dezign from Datanamic. Unfortunately, it does not
handle the PG use of triggers to implement foreign key referential
integrity. We can generate the PG database from Dezign without problem not
using triggers for foreign keys.

Our main objective is to be able to implement changes in a production data
base and then be able to update the model so that we have updated
documentation and a model which can generate a script to create the database.

If the DB model program can create scripts to alter [non-destructively] a
database based upon changes to the model, then we could use this also.

At 09:05 AM 3/27/2003 -0800, Dennis Gearon wrote:
>Try the company:
>
> http://www.datanamic.com/
>
>Paul Rosenberg wrote:
>>We are looking for a DB design program which can reverse engineer a PG
>>database. We want to use this to create revised documentation for the
>>database after changes are made. PG outputs a creation SQL script
>>which uses triggers to define foreign keys and this seems to be
>>unusual and has caused a problem with one software.
>>
>>---------------------------(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)