Hi, how about, dia - http://www.gnome.org/projects/dia/ have not used myself, but AFAIK UML diagrams are possible. umbrello - http://uml.sourceforge.net/index.php UML and ERD diagrams. regards, Iges. On Friday, 25. November 2005 12:01, Nikolay Samokhvalov wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend
