Skip to main content

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.

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

Installation

Building Psycopg requires a few prerequisites (a C compiler, some development packages): please check the install and the faq documents in the doc dir or online for the details.

If prerequisites are met, you can install psycopg like any other Python package, using pip to download it from PyPI:

$ pip install psycopg2

or using setup.py if you have downloaded the source package locally:

$ python setup.py build
$ sudo python setup.py install

You can also obtain a stand-alone package, not requiring a compiler or external libraries, by installing the psycopg2-binary package from PyPI:

$ pip install psycopg2-binary

The binary package is a practical choice for development and testing but in production it is advised to use the package built from sources.

Linux/OSX:

Linux and OSX build status

Windows:

Windows build status

Project details


Download files

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

Source Distribution

psycopg2-2.8.2.tar.gz (368.2 kB view details)

Uploaded Source

Built Distributions

psycopg2-2.8.2-cp37-cp37m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.7m Windows x86-64

psycopg2-2.8.2-cp37-cp37m-win32.whl (978.7 kB view details)

Uploaded CPython 3.7m Windows x86

psycopg2-2.8.2-cp36-cp36m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.6m Windows x86-64

psycopg2-2.8.2-cp36-cp36m-win32.whl (978.7 kB view details)

Uploaded CPython 3.6m Windows x86

psycopg2-2.8.2-cp35-cp35m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.5m Windows x86-64

psycopg2-2.8.2-cp35-cp35m-win32.whl (978.6 kB view details)

Uploaded CPython 3.5m Windows x86

psycopg2-2.8.2-cp34-cp34m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.4m Windows x86-64

psycopg2-2.8.2-cp34-cp34m-win32.whl (996.7 kB view details)

Uploaded CPython 3.4m Windows x86

psycopg2-2.8.2-cp27-cp27m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 2.7m Windows x86-64

psycopg2-2.8.2-cp27-cp27m-win32.whl (989.7 kB view details)

Uploaded CPython 2.7m Windows x86

File details

Details for the file psycopg2-2.8.2.tar.gz.

File metadata

  • Download URL: psycopg2-2.8.2.tar.gz
  • Upload date:
  • Size: 368.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2.tar.gz
Algorithm Hash digest
SHA256 5cacf21b6f813c239f100ef78a4132056f93a5940219ec25d2ef833cbeb05588
MD5 74cbe0f09a6ebafd107f89c858120bd5
BLAKE2b-256 237e93c325482c328619870b6cd09370f6dbe1148283daca65115cd63642e60f

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp37-cp37m-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 3.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 61f58e9ecb9e4dc7e30be56b562f8fc10ae3addcfcef51b588eed10a5a66100d
MD5 4b3143bf88f2eaa8855200ceb9956b48
BLAKE2b-256 3e912e9221309c4507a99048c76ce97b6daafe7ff507d8df0b66dbb8e94685b9

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp37-cp37m-win32.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 978.7 kB
  • Tags: CPython 3.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 076501fc24ae13b2609ba2303d88d4db79072562f0b8cc87ec1667dedff99dc1
MD5 7c5af8ba09c841944d4d745611b6acb4
BLAKE2b-256 00f3afd8570a32712953c83e6ba2d3ce3c7cfaa6eeeebf8879da14731445b793

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp36-cp36m-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp36-cp36m-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 3.6m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 00cfecb3f3db6eb76dcc763e71777da56d12b6d61db6a2c6ccbbb0bff5421f8f
MD5 5f9789031d74a1cd79827a341ed42dc7
BLAKE2b-256 f3351606d866014b4f9a2da2f57f5537b62d67ad3ef79842e61e474a9c7585d2

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp36-cp36m-win32.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 978.7 kB
  • Tags: CPython 3.6m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 dee885602bb200bdcb1d30f6da6c7bb207360bc786d0a364fe1540dd14af0bab
MD5 4f443ee2d19c09efda3478c70eb4d528
BLAKE2b-256 df03ea164ef9d64c738bd84999a1a9cdeb4c138e923e8da56358bbe75c80d0bf

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp35-cp35m-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp35-cp35m-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 3.5m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 de3d3c46c1ee18f996db42d1eb44cf1565cc9e38fb1dbd9b773ff6b3fa8035d7
MD5 c7e075eabb7657f962e4a53b28fdd5f5
BLAKE2b-256 feb5ed2c89e94762cddbf0ddd94878c65e0809ec68df84c1fc5956a5aeb1eb87

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp35-cp35m-win32.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp35-cp35m-win32.whl
  • Upload date:
  • Size: 978.6 kB
  • Tags: CPython 3.5m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 bb1735378770fb95dbe392d29e71405d45c8bdcfa064f916504833a92ab03c55
MD5 a12aa1951b74d766abd77ed0a3663ea3
BLAKE2b-256 0dda853afebfd0ecaea88858b385a84b821ef031dc8c0b9f7cf8f8bec72bab98

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp34-cp34m-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp34-cp34m-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 3.4m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 8954ff6e47247bdd134db602fcadfc21662835bd92ce0760f3842eacfeb6e0f3
MD5 bd3b62f8b1f03e9767cf28c2f8caf202
BLAKE2b-256 5feed59b44d4ae8d8fbaad72843c6c8a2bb7f74004a2c5a3cf5afea75a9ff168

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp34-cp34m-win32.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp34-cp34m-win32.whl
  • Upload date:
  • Size: 996.7 kB
  • Tags: CPython 3.4m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 4e2b34e4c0ddfeddf770d7df93e269700b080a4d2ec514fec668d71895f56782
MD5 21558fc76e10477060b7cd7a28be70c2
BLAKE2b-256 b426dc220b8892f403d7fc3f0f8eb8094d0b482d6f127d16a06cf54a7073e1a6

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp27-cp27m-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp27-cp27m-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 2.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 baca21c0f7344576346e260454d0007313ccca8c170684707a63946b27a56c8f
MD5 96c33179b20ad5e886df034bc6fcfdde
BLAKE2b-256 bb92b2316384cb2f194628b21cad5c185f09ec98777bad7bed3c1c8bb784959e

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.8.2-cp27-cp27m-win32.whl.

File metadata

  • Download URL: psycopg2-2.8.2-cp27-cp27m-win32.whl
  • Upload date:
  • Size: 989.7 kB
  • Tags: CPython 2.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.5.0 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/2.7.15rc1

File hashes

Hashes for psycopg2-2.8.2-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 b6e8c854cdc623028e558a409b06ea2f16d13438335941c7765d0a42b5bedd33
MD5 9c8823f4c21da278e5bbb446d7f8c685
BLAKE2b-256 318d0930a7fa14ff33d77f4b2a8771827c29b2775267f0ba498c697531d984e9

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page