Graphical modelling tool

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