For Windows users, HeidiSQL is a very solid open source client for interacting with Postgres.