My favorite postgres gui by far has been Psequel.

http://www.psequel.com/