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

Uploaded Source

Built Distributions

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

Uploaded CPython 3.9Windows x86-64

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

Uploaded CPython 3.9Windows x86

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

Uploaded CPython 3.8Windows x86-64

psycopg2-2.8.6-cp38-cp38-win32.whl (987.3 kB view details)

Uploaded CPython 3.8Windows x86

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

Uploaded CPython 3.7mWindows x86-64

psycopg2-2.8.6-cp37-cp37m-win32.whl (984.8 kB view details)

Uploaded CPython 3.7mWindows x86

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

Uploaded CPython 3.6mWindows x86-64

psycopg2-2.8.6-cp36-cp36m-win32.whl (984.8 kB view details)

Uploaded CPython 3.6mWindows x86

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

Uploaded CPython 3.5mWindows x86-64

psycopg2-2.8.6-cp35-cp35m-win32.whl (984.7 kB view details)

Uploaded CPython 3.5mWindows x86

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

Uploaded CPython 3.4mWindows x86-64

psycopg2-2.8.6-cp34-cp34m-win32.whl (1.0 MB view details)

Uploaded CPython 3.4mWindows x86

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

Uploaded CPython 2.7mWindows x86-64

psycopg2-2.8.6-cp27-cp27m-win32.whl (995.3 kB view details)

Uploaded CPython 2.7mWindows x86

File details

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

File metadata

  • Download URL: psycopg2-2.8.6.tar.gz
  • Upload date:
  • Size: 383.8 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.2

File hashes

Hashes for psycopg2-2.8.6.tar.gz
Algorithm Hash digest
SHA256 fb23f6c71107c37fd667cb4ea363ddeb936b348bbd6449278eb92c189699f543
MD5 ae2ff92f1cfcd890bd5f09f4d1d7d60c
BLAKE2b-256 fdae98cb7a0cbb1d748ee547b058b14604bd0e9bf285a8e0cc5d148f8a8a952e

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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.8.6-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 d5062ae50b222da28253059880a871dc87e099c25cb68acf613d9d227413d6f7
MD5 3e522b5e97ac2be9dd3871de0d4b0917
BLAKE2b-256 d6ebba556d3d642fedf220e2e7e4f16085d6f1f0363a1670fc4b72a26f497c5c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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.8.6-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 2c93d4d16933fea5bbacbe1aaf8fa8c1348740b2e50b3735d1b0bf8154cbf0f3
MD5 9eb5b32b7db6c01264eedc6908410e29
BLAKE2b-256 0013ce81fc492fb61f33e2dd247e638c4c8a2187c58864e61a04de8496429e6e

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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.2

File hashes

Hashes for psycopg2-2.8.6-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 56007a226b8e95aa980ada7abdea6b40b75ce62a433bd27cec7a8178d57f4051
MD5 b64bbfb335db761c3d2a5936d5bbc888
BLAKE2b-256 18354be44fc779e8c8a7aedc4b19bf91dcd476edabd471b4d7c82f216b5ba271

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp38-cp38-win32.whl
  • Upload date:
  • Size: 987.3 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.2

File hashes

Hashes for psycopg2-2.8.6-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 ad2fe8a37be669082e61fb001c185ffb58867fdbb3e7a6b0b0d2ffe232353a3e
MD5 7e5d6a5a1a539efb3da0e202f2aa0445
BLAKE2b-256 6f8f89b52c494dfb7f4f4c251e310b78b49f204ce0386f28316a92413e0e60bf

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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.2

File hashes

Hashes for psycopg2-2.8.6-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 56fee7f818d032f802b8eed81ef0c1232b8b42390df189cab9cfa87573fe52c5
MD5 ee9da6b749826a389582a425d430ee60
BLAKE2b-256 441fa6ae3527568bb9a3d49339beb630ede2dcb345c88cc3cdc2a6dfbb78110e

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 984.8 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.2

File hashes

Hashes for psycopg2-2.8.6-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 6a3d9efb6f36f1fe6aa8dbb5af55e067db802502c55a9defa47c5a1dad41df84
MD5 be4a702b5f10c533528a94edd38eac36
BLAKE2b-256 e408c0ad8002f69d4d31a656ed1a865f6cc6b3b781f03b6525455e3a79281a94

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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.2

File hashes

Hashes for psycopg2-2.8.6-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 f974c96fca34ae9e4f49839ba6b78addf0346777b46c4da27a7bf54f48d3057d
MD5 ce041fd03734b1dc66df1018afa8ccc4
BLAKE2b-256 fd09b6c3e8442db0342629d1c95e9c451d7ee0920f6c1152edcc0d4bd0ee7ade

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 984.8 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.2

File hashes

Hashes for psycopg2-2.8.6-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 a49833abfdede8985ba3f3ec641f771cca215479f41523e99dace96d5b8cce2a
MD5 2de5a47f7ae3ef2bcd57c581cd34ce43
BLAKE2b-256 9f6fec0689612a630f2b34c734c3d8db40f9a385898dec14f49306ed73c2ecd5

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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/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.2

File hashes

Hashes for psycopg2-2.8.6-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 00195b5f6832dbf2876b8bf77f12bdce648224c89c880719c745b90515233301
MD5 cbd99cef3fcc13318f8aaba3043a5981
BLAKE2b-256 e3a8aa3d862173bfcc2f7d4a00516c293bc1c660933b35909c4373025636f508

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp35-cp35m-win32.whl
  • Upload date:
  • Size: 984.7 kB
  • Tags: CPython 3.5m, 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.2

File hashes

Hashes for psycopg2-2.8.6-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 26e7fd115a6db75267b325de0fba089b911a4a12ebd3d0b5e7acb7028bc46821
MD5 2174dc3c4b2a811779890cc7a60fcc18
BLAKE2b-256 902453f39fde488210c09869ac6bade7cfefa982fe542197716b190bac826733

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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/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.2

File hashes

Hashes for psycopg2-2.8.6-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 f22ea9b67aea4f4a1718300908a2fb62b3e4276cf00bd829a97ab5894af42ea3
MD5 0bad640fd3a2ec04a8c34e5443540995
BLAKE2b-256 ecc072786579c3d8e87b9b602c32c633c36dc20e346bddbcc506b1085513f8f8

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp34-cp34m-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.4m, 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.2

File hashes

Hashes for psycopg2-2.8.6-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 b8cae8b2f022efa1f011cc753adb9cbadfa5a184431d09b273fb49b4167561ad
MD5 bbf579c34cf14ae6519c85d377db3fc6
BLAKE2b-256 d514cf8f9edb6aa1a7eea9587ee446276974b3096b5abed63e28323ede746397

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-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/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.2

File hashes

Hashes for psycopg2-2.8.6-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 d160744652e81c80627a909a0e808f3c6653a40af435744de037e3172cf277f5
MD5 580483ff1be30c0bb8cd9a396fd4d99a
BLAKE2b-256 bcc10bf0150848f600be3839b1ea01b037d6355e191486f04c6f3af4e75d1b38

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.6-cp27-cp27m-win32.whl
  • Upload date:
  • Size: 995.3 kB
  • Tags: CPython 2.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.2

File hashes

Hashes for psycopg2-2.8.6-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 068115e13c70dc5982dfc00c5d70437fe37c014c808acce119b5448361c03725
MD5 f7b2d6553b373a08d0d9705a05b85979
BLAKE2b-256 f41fca233a88530fb2ad7b6fa291765a55ec9fb7573c454f576e55ac232b0252

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