PGDesigner is a simple data modelling tool for PostgreSQL. It currently supports graphically creating tables and columns, drag and drop foreign key creation, loading and saving models to a file, and is able to generate SQL code from your graphical model. It also has a simple query window that allows arbitrary SQL commands to be executed. It is available for Linux and Windows.
