I don't think it will generate SQL scripts, but you might look at Dia
(think Visio for Linux/Windows). I've never used, but I've thought about
it a couple of times...
http://www.lysator.liu.se/~alla/dia/
from their homepage...
---------------------------------------------------------------------------
Dia is a gtk+ based diagram creation program released under the GPL
license.
Dia is designed to be much like the commercial Windows program 'Visio'. It
can be used to draw many different kinds of diagrams. It currently has
special objects to help draw entity relationship diagrams, UML diagrams,
flowcharts, network diagrams, and simple circuits. It is also possible to
add support for new shapes by writing simple XML files, using a subset of
SVG to draw the shape.
It can load and save diagrams to a custom XML format (gzipped by default,
to save space), can export diagrams to EPS or SVG formats and can print
diagrams (including ones that span multiple pages).
---------------------------------------------------------------------------
On 1 Oct 2002, Bill wrote:
> Are there really no open-source design tools for pg on any platform
> other than windows? I've checked on GBorg and all I found were windows
> apps and a general web search has yielded only one possible candidate,
> gnome-db (which i have no yet evaluated).
>
> What are others on linux using to build their db's.
>
> Thanks in advance
>
> -bill
>
> Bill Halpin
> Collaborative Fusion
> Pittsburgh, Pa
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>