I usually upgrade to the next-gen ubuntu release a month or two before it comes out so I can test QGIS and other software on the new platform. Today I was looking for a visual query designer for PostgreSQL because I wanted to make some complex queries with multiple joins. I’m ok for dealing with a few simple joins when hand writing my SQL but when things get complex, having a visual query builder is a great time saver.

Mas:

http://linfiniti.com/2009/10/visual-postgresql-query-builder-coming-in-karmic/