I wrote a little app that does basically what you're looking for:
http://www.hardgeus.com/projects/pgdesigner/
It's not professional quality, and is a little flaky, but it gets the
job done. It has a wxGTK dependency, and of course postgres. Your best
bet for running it is to pull it from my CVS server (instructions on
page) rather than trying the binaries etc.
Thomas Hallgren wrote:
> Hi,
> I'm about to start a new project where the first task is to design a
> database. I'm looking for some tool that will allow me to model the
> tables and relationships graphically, UML or similar, and then let me
> generate the SQL with PostgreSQL flavor. What's the best tools out
> there? Are there any open source alternatives?
>
> Kind regards,
> Thomas Hallgren
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match