Here's a few, partially shameless plugs, of similar articles that have some overlap but hit some other niceties of psql.

http://www.craigkerstiens.com/2013/02/21/more-out-of-psql/

http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Pos...