I've used DbVisualizer, a free-as-in-beer app. It's in Java and connects to the database through JDBC. You need to use the PG 7.2's JDBC driver, even if running PG 7.1 or lower.
It does the entity-relation thingy quite well. http://www.minq.se/products/dbvis/dbvis3.html