Skip to main content
Warning: You are using the test version of PyPI. This is a pre-production deployment of Warehouse. Changes made here affect the production instance of TestPyPI (
Help us improve Python packaging - Donate today!

psycopg2 - Python-PostgreSQL Database Adapter

Project Description

Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent “INSERT”s or “UPDATE”s.

Psycopg 2 is mostly implemented in C as a libpq wrapper, resulting in being both efficient and secure. It features client-side and server-side cursors, asynchronous communication and notifications, “COPY TO/COPY FROM” support. Many Python types are supported out-of-the-box and adapted to matching PostgreSQL data types; adaptation can be extended and customized thanks to a flexible objects adaptation system.

Psycopg 2 is both Unicode and Python 3 friendly.


Documentation is included in the doc directory and is available online.


If your pip version supports wheel packages it should be possible to install a binary version of Psycopg including all the dependencies from PyPI. Just run:

$ pip install -U pip      # make sure your pip is up-to-date
$ pip install psycopg2

If you want to build Psycopg from source you will need some prerequisites (a C compiler, development packages): please check the install and the faq documents in the doc dir for the details.

For any other resource (source code repository, bug tracker, mailing list) please check the project homepage.

Release History

Release History

This version
History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
psycopg2-2.7.3-cp26-cp26m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Jul 24, 2017
psycopg2-2.7.3-cp26-cp26m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Jul 24, 2017
psycopg2-2.7.3-cp26-cp26mu-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Jul 24, 2017
psycopg2-2.7.3-cp26-cp26mu-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Jul 24, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting