Re: tool for DB design

Nikolay Samokhvalov schrieb:
> dbvis isn't the thing what I need. Or I'm blind and cannot find where
> I can draw ER/UML diagram then transform it to physical, then obtain
> SQL code. Or, just physical->SQL. Please correct me if I'm wrong.

Well, I mentioned DIA for this - reread my mail please ;)
I said DIA for ER -> SQL and dbvis for physical -> ER.
physical -> SQL is covered by pg_dump.

> On 25/11/05, Tino Wildenhain <tino(at)wildenhain(dot)de> wrote:
>
>>Am Freitag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov:
>>
>>>Please, suggest any free/opensource tool for DB design under Linux. I
>>>need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
>>>don't even dream about reverse transformation...) Quite good example
>>>of such tool is Sybase PowerDesigner (which supports Postgres), but
>>>AFAIK it runs only under win and costs $...
>>
>>dia can do this and I guess a lot of other tools.
>>For the reverse check out db visualizer (dbvis)
>>http://www.minq.se/products/dbvis/
>>
>>Which has a very nice ER-view.
>>(With autorouting, which many tools, even the $$$-ones
>> miss)
>>
>>++Tino
>>
>>
>
>
>
> --
> Best regards,
> Nikolay