I wrote a little LGPL app that generates Postgres SQL code from a
graphical datamodel. It's not professional quality, but it functions.
I don't actively maintain it, but I still use it for brainstorming
datamodels and quick generation of the database.
http://www.hardgeus.com/projects/pgdesigner/
Tino Wildenhain wrote:
> 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@wildenhain.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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings