A new, final section in "Data Objects" should provide a reasonable illustration of how Postgres' type hierarchy is represented in Python. Chances are that the data objects section leaves a number of questions unanswered, so this should help shine some light on the topic.