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.9.1.tar.gz (380.0 kB view details)

Uploaded Source

Built Distributions

psycopg2-2.9.1-cp310-cp310-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.10Windows x86-64

psycopg2-2.9.1-cp310-cp310-win32.whl (1.0 MB view details)

Uploaded CPython 3.10Windows x86

psycopg2-2.9.1-cp39-cp39-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.9Windows x86-64

psycopg2-2.9.1-cp39-cp39-win32.whl (1.0 MB view details)

Uploaded CPython 3.9Windows x86

psycopg2-2.9.1-cp38-cp38-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.8Windows x86-64

psycopg2-2.9.1-cp38-cp38-win32.whl (995.9 kB view details)

Uploaded CPython 3.8Windows x86

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

Uploaded CPython 3.7mWindows x86-64

psycopg2-2.9.1-cp37-cp37m-win32.whl (994.3 kB view details)

Uploaded CPython 3.7mWindows x86

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

Uploaded CPython 3.6mWindows x86-64

psycopg2-2.9.1-cp36-cp36m-win32.whl (994.4 kB view details)

Uploaded CPython 3.6mWindows x86

File details

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

File metadata

  • Download URL: psycopg2-2.9.1.tar.gz
  • Upload date:
  • Size: 380.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1.tar.gz
Algorithm Hash digest
SHA256 de5303a6f1d0a7a34b9d40e4d3bef684ccc44a49bbe3eb85e3c0bffb4a131b7c
MD5 182e3e8cf3381c254f65f70cad4976e5
BLAKE2b-256 aa8a7c80e7e44fb1b4277e89bd9ca509aefdd4dd1b2c547c6f293afe9f7ffd04

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp310-cp310-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.10, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.10

File hashes

Hashes for psycopg2-2.9.1-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 e5a8ed9dbfca8dc162c4ada5ab017e10d5a66c542b4c73569f103fa5f342f498
MD5 1cece97c7023c14b29b4713ddb791da7
BLAKE2b-256 db0bd77e1d1d39fafecbfa4c6c17e8f011076650bd6911925256978b7976a22e

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp310-cp310-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp310-cp310-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.10, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.10

File hashes

Hashes for psycopg2-2.9.1-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 25615574419dd9bda6fdfdcd58afb22e721f5b807cb3d5e62f488c8acf8cb754
MD5 c1c8b9f1926a66e1d1d30aa692ea5177
BLAKE2b-256 9dee69cf31cf460b10ff3b9bfab87d5125bfecd77b1af4732b59c55d2e4666f3

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 bf35a25f1aaa8a3781195595577fcbb59934856ee46b4f252f56ad12b8043bcf
MD5 b28389302123e4d6dba68f12c7f23f24
BLAKE2b-256 f8e0d56285697799cc754fcfc42ed0d690b48cce67add623acce84b61b20f01a

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp39-cp39-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp39-cp39-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.9, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 2087013c159a73e09713294a44d0c8008204d06326006b7f652bef5ace66eebb
MD5 cc5ecdd3a57c54c18ca10c596010d20f
BLAKE2b-256 59318f1e22dd2eb287fa48269763c902355552ee9b48ff606fab4683ed3e6e2c

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp38-cp38-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 1.1 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 2c992196719fadda59f72d44603ee1a2fdcc67de097eea38d41c7ad9ad246e62
MD5 4ed1e90e585d294b5d684d69016dfa19
BLAKE2b-256 71725f9d608c0aa120f8ea21cac9bd4e9f5bd515444ab96af98bea47ffcd8c20

See more details on using hashes here.

File details

Details for the file psycopg2-2.9.1-cp38-cp38-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.1-cp38-cp38-win32.whl
  • Upload date:
  • Size: 995.9 kB
  • Tags: CPython 3.8, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 079d97fc22de90da1d370c90583659a9f9a6ee4007355f5825e5f1c70dffc1fa
MD5 998b7162213f88083bdb832d42fbf2f0
BLAKE2b-256 5824c2b3cf300964e9f37349932364c0b00e3bb3613c7e14f05240b7eb38e278

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.9.1-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/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 7640e1e4d72444ef012e275e7b53204d7fab341fb22bc76057ede22fe6860b25
MD5 5b1090c724d3a3b82428927dbb32be10
BLAKE2b-256 754a3d5781fa2669851b756eab27d94c1c0d90bbdb2a40050dff0a993daf2c2c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.9.1-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 994.3 kB
  • Tags: CPython 3.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 89409d369f4882c47f7ea20c42c5046879ce22c1e4ea20ef3b00a4dfc0a7f188
MD5 a7965ab351329eb93709d1bc7817e463
BLAKE2b-256 c6ae3b17e2761abbe9832f220ca9f7d46d8072eb2407ac183efee4d69f8a83af

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.9.1-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/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 830c8e8dddab6b6716a4bf73a09910c7954a92f40cf1d1e702fb93c8a919cc56
MD5 5ccbfad20b21b34ccc151bf31086df3c
BLAKE2b-256 d4abc7cbb9aa73e3623a27e5c7762cf4a1ca6570b9c862aeb1b36ef5b9f17c68

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.9.1-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 994.4 kB
  • Tags: CPython 3.6m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/44.0.0 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for psycopg2-2.9.1-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 7f91312f065df517187134cce8e395ab37f5b601a42446bdc0f0d51773621854
MD5 ce52bb45ef640caea25204f5aac62055
BLAKE2b-256 13d8cdd0ed4a72d4283963b148bf719b939bd5550a8e94a22fc7593a857e6bea

See more details on using hashes here.

Supported by

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