Postgres Tools

About 6 months ago I migrated the major project I am responsible for from MSSQL Server to Postgresql. The move was fundamentally easy, stress free and opened up opportunities to start using Geo-Spatial queries. This is my second experience of Postgres, it has moved on heaps and there are some good third party tools available, which makes life much easier and opens the product to less techy people.

Some useful tools are available for Postgres including Aqua Data Studio which is the equivelant to Query Analyser (and can point to MSSQL anyway). It is much faster also. Additionally I have found EMS PostgreSQL Manager 2 to be invaluable.