> Can anyone tell me which free GUI based tools are available for
> creating database diagrams for my database in postgresql.
One standard answer to this frequently asked question is:
http://www.databaseanswers.org/modelling_tools.htm
Sincerely,
Wolfgang