PgAccess is, as name implies, a program for accessing PostgreSQL databases. It's a visual database management program that can show the contents of the database and lets you change it; you don't need to know SQL to use it¹. It also has support for report generation, forms, and scripting.
It was written by Constantin Teodorescu in Tcl/Tk, and runs on *NIX and Windows.
Homepage, as of writing: http://ns.flex.ro/pgaccess/
¹ I know, these are the Famous Last Words in every occasion...