Navicat (PostgreSQL client) - 6.1.5

Despite the noted problems with not null columns and schemas, this is the best postgres gui I have tried for one simple reason: the multi-document model. When you click in the main window to do anything it opens a new window that is part of the same running instance. This means that you can use expose [F10] to view the open windows side by side, which is very helpful for a relational database set-up (i.e., when most columns are integers referring to entries in other tables). To compare free products you can use expose for Aqua Data Studio by using its Edit Table option, but there is no equivalent Edit Views option despite the fact that in many of ADS's supported database engines views are partially updatable. In Bigger SQL and PGnJ you can open a new connection, but in expose terms that is a separate instance and so can only be viewed by F9, where the windows tend to be too small to be much use.

The one thing holding me back from purchasing Navicat is its upgrade policy. It is free upgrades for minor revisions. As the Windows versions are at 7 and the OSX at 6 there is the danger of buying now and finding that the OSX bugs are fixed in a version for which you have to pay again. A license covering a major upgrade in the first 12 months would be better. This is particularly a problem in a product that is clearly a port from MySQL Navicat (e.g., you can only create rules in design table, when rules are the way to make a view updatable.)