Postgres visual database design tool for Linux

Question

I'm not looking for something like phpPgAdmin or pgAdmin III. I'm looking for something similar to MySQL Workbench. A tool to design databases visually and convert those visual designs into queries that will generate the database. It should also be able to create a visual representation of an existing database and use that visual representation to reverse-engineer that database. Is there such tool available for Linux?

Of course, it should be free.

Answer 1

Power*Architect

Answer 2

Try DBvisualizer, a tool that is both free and flexible. It can work with ODBC, JDBC, etc. Also supporting Postgres.

A major advantage of MySQL Query Browser is the ability to instantly edit fields. I haven't found that functionality in DBvisualizer yet, but I could be mistaken.

It is a very nice tool for many db purposes.