Re: tool for DB design - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: tool for DB design
Date
Msg-id 4386F3EC.7030509@wildenhain.de
Whole thread Raw
In response to Re: tool for DB design  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Responses Re: tool for DB design  (John McCawley <nospam@hardgeus.com>)
Re: tool for DB design  (William Bug <William.Bug@drexel.edu>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: pg_dump --data-only: is dump ordered to keep foreign-key-relations
Next
From: seem.iges@mail.ee
Date:
Subject: Re: tool for DB design