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 (testpypi.python.org).
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

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

Installation

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

pip install psycopg2

If you want to build Psycopg from source you will need some prerequisite (a C compiler, Python and libpq development packages). If you have what you need the standard:

python setup.py build
sudo python setup.py install

should work no problem. In case you have any problem check the ‘install’ and the ‘faq’ documents in the docs or online.

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

Linux/OSX:
Windows:
Release History

Release History

This version
History Node

2.7.1

History Node

2.7

History Node

2.7rc2

History Node

2.7rc1

History Node

2.7b2

History Node

2.7b1

History Node

2.7.dev0

History Node

2.6.3.dev0

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.1-cp26-cp26m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Mar 13, 2017
psycopg2-2.7.1-cp26-cp26m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Mar 13, 2017
psycopg2-2.7.1-cp26-cp26mu-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Mar 13, 2017
psycopg2-2.7.1-cp26-cp26mu-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp26 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27mu-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27mu-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27m-win32.whl (805.2 kB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp27-cp27m-win_amd64.whl (930.3 kB) Copy SHA256 Checksum SHA256 cp27 Wheel Mar 13, 2017
psycopg2-2.7.1-cp33-cp33m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp33 Wheel Mar 13, 2017
psycopg2-2.7.1-cp33-cp33m-manylinux1_x86_64.whl (2.6 MB) Copy SHA256 Checksum SHA256 cp33 Wheel Mar 13, 2017
psycopg2-2.7.1-cp33-cp33m-win32.whl (809.6 kB) Copy SHA256 Checksum SHA256 cp33 Wheel Mar 13, 2017
psycopg2-2.7.1-cp33-cp33m-win_amd64.whl (928.6 kB) Copy SHA256 Checksum SHA256 cp33 Wheel Mar 13, 2017
psycopg2-2.7.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) Copy SHA256 Checksum SHA256 cp34 Wheel Mar 13, 2017
psycopg2-2.7.1-cp34-cp34m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp34 Wheel Mar 13, 2017
psycopg2-2.7.1-cp34-cp34m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp34 Wheel Mar 13, 2017
psycopg2-2.7.1-cp34-cp34m-win32.whl (809.4 kB) Copy SHA256 Checksum SHA256 cp34 Wheel Mar 13, 2017
psycopg2-2.7.1-cp34-cp34m-win_amd64.whl (928.6 kB) Copy SHA256 Checksum SHA256 cp34 Wheel Mar 13, 2017
psycopg2-2.7.1-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) Copy SHA256 Checksum SHA256 cp35 Wheel Mar 13, 2017
psycopg2-2.7.1-cp35-cp35m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp35 Wheel Mar 13, 2017
psycopg2-2.7.1-cp35-cp35m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp35 Wheel Mar 13, 2017
psycopg2-2.7.1-cp35-cp35m-win32.whl (800.5 kB) Copy SHA256 Checksum SHA256 cp35 Wheel Mar 13, 2017
psycopg2-2.7.1-cp35-cp35m-win_amd64.whl (939.3 kB) Copy SHA256 Checksum SHA256 cp35 Wheel Mar 13, 2017
psycopg2-2.7.1-cp36-cp36m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) Copy SHA256 Checksum SHA256 cp36 Wheel Mar 13, 2017
psycopg2-2.7.1-cp36-cp36m-manylinux1_i686.whl (2.4 MB) Copy SHA256 Checksum SHA256 cp36 Wheel Mar 13, 2017
psycopg2-2.7.1-cp36-cp36m-manylinux1_x86_64.whl (2.7 MB) Copy SHA256 Checksum SHA256 cp36 Wheel Mar 13, 2017
psycopg2-2.7.1-cp36-cp36m-win32.whl (800.4 kB) Copy SHA256 Checksum SHA256 cp36 Wheel Mar 13, 2017
psycopg2-2.7.1-cp36-cp36m-win_amd64.whl (939.2 kB) Copy SHA256 Checksum SHA256 cp36 Wheel Mar 13, 2017
psycopg2-2.7.1.tar.gz (421.0 kB) Copy SHA256 Checksum SHA256 Source Mar 13, 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