Re: Reverse engineering PG database

I am part of the beta test program, the next version will do those.

Paul Rosenberg wrote:
> 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)