Re: tool for DB design

From: seem(dot)iges(at)mail(dot)ee
To: pgsql-general(at)postgresql(dot)org
Subject: Re: tool for DB design
Date: 2005-11-25 10:15:31
Message-ID: 200511251215.31241.seem.iges@mail.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergio Trujillo 2005-11-25 10:23:28 I need a teacher in Huelva, Spain...
Previous Message Harald Armin Massa 2005-11-25 10:15:02 Re: pg_dump --data-only: is dump ordered to keep foreign-key-relations loadable?