This is the PostgreSQL project page. It contains the downloads and docs for the Postgre database.
http://initd.org/projects/psycopg1
You need the psycopg package for PostgreSQL. This page contains information on the psycopg package and a link to download it.
http://stickpeople.com/projects/python/win-psycopg/
This page contains information and a download link for the Windows version of the psycopg package for Postgre.