Peter Eisentraut has written some good slides on coding PostgreSQL clients in Python and on using Python as a stored procedures language in PostgreSQL.
First half deals with using Python as a Postgres client. Second half deals with coding stored procedures in Python.