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. On 25/11/05, Tino Wildenhain <tino@xxxxxxxxxxxxx> 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