If you want to use a GUI, you might want to use PgAdmin 3, which is the "official" GUI for Postgres. It needs exactly the same configuration than psql for connecting to the database. However ...

let’s load a stock database that’s already in Postgres format. I wanted to use one of the PgFoundry Sample Databases, but alas, that site is no longer active. Entity-relationship diagrams like ...