Quantum GIS (QGIS) is a user friendly Open Source GIS that runs on Linux, Unix, Mac OSX, and Windows.
Homepage: QGIS
It's written in C and uses libraries from Python, OGR, GDAL and PROJ. Can read PostGIS...