A new guide has been published: How to Use Psycopg2 to Connect Python to PostgreSQL
A tutorial on connecting Python to PostgreSQL using Psycopg2 can be found on Linux Hint.
Read more @ Linux Compatible