Comment by skb_

I found the postgres manual [1] to be quite sufficient. It covers pretty much anything you might want to do.

[1] - http://www.postgresql.org/docs/9.1/static/