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

Uploaded Source

Built Distributions

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

Uploaded CPython 3.7m Windows x86-64

psycopg2-2.8.3-cp37-cp37m-win32.whl (979.2 kB view details)

Uploaded CPython 3.7m Windows x86

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

Uploaded CPython 3.6m Windows x86-64

psycopg2-2.8.3-cp36-cp36m-win32.whl (979.2 kB view details)

Uploaded CPython 3.6m Windows x86

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

Uploaded CPython 3.5m Windows x86-64

psycopg2-2.8.3-cp35-cp35m-win32.whl (979.2 kB view details)

Uploaded CPython 3.5m Windows x86

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

Uploaded CPython 3.4m Windows x86-64

psycopg2-2.8.3-cp34-cp34m-win32.whl (997.2 kB view details)

Uploaded CPython 3.4m Windows x86

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

Uploaded CPython 2.7m Windows x86-64

psycopg2-2.8.3-cp27-cp27m-win32.whl (990.1 kB view details)

Uploaded CPython 2.7m Windows x86

File details

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

File metadata

  • Download URL: psycopg2-2.8.3.tar.gz
  • Upload date:
  • Size: 377.3 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.3.tar.gz
Algorithm Hash digest
SHA256 897a6e838319b4bf648a574afb6cabcb17d0488f8c7195100d48d872419f4457
MD5 bc00aa77595c03af7d68876ceb74ef77
BLAKE2b-256 5c1c6997288da181277a0c29bc39a5f9143ff20b8c99f2a7d059cfb55163e165

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-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.3-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 cb407fccc12fc29dc331f2b934913405fa49b9b75af4f3a72d0f50f57ad2ca23
MD5 6bb1895bd9eba29df127fcecc87a86d4
BLAKE2b-256 3bb4b6db75663e1c73bb6190cbcbb02f94a36c574b813a353446087cbdf43712

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 979.2 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.3-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 227fd46cf9b7255f07687e5bde454d7d67ae39ca77e170097cdef8ebfc30c323
MD5 7684bcba6bf8b2ceeb0ba3f79b150f3e
BLAKE2b-256 692157e12f1c47d8a540e502f098f5ab5d54db099c95fbaa5791239ac4e8a86f

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-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.3-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 d3a27550a8185e53b244ad7e79e307594b92fede8617d80200a8cce1fba2c60f
MD5 ba82d5eec0a5d765e746e750db0df0d5
BLAKE2b-256 b285a8ea3d7d7d3ee07aa30c5d8d098022ed17fdba8d360c42d46069d72c9500

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 979.2 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.3-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 8dceca81409898c870e011c71179454962dec152a1a6b86a347f4be74b16d864
MD5 a3f28ffb7ffa458db9a05fab11d4c087
BLAKE2b-256 68f8e11270d59030163fb849b0de8ead6d2ba380990491e77998dfd3d69663e0

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-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.3-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 f0e6b697a975d9d3ccd04135316c947dd82d841067c7800ccf622a8717e98df1
MD5 47b3d8058e553591e7a979de54e18281
BLAKE2b-256 1fee5728d5bb8bf85e3c5f1dfacb8ebdd98119f8c0c61a4c4d4ed88cd7bd5210

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-cp35-cp35m-win32.whl
  • Upload date:
  • Size: 979.2 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.3-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 128d0fa910ada0157bba1cb74a9c5f92bb8a1dca77cf91a31eb274d1f889e001
MD5 f11041f155517f2feb85363bfd8e886a
BLAKE2b-256 fe06cbc1c1cf8704bdd1cf9e338c5740f58918992d89b42ad832feb5197666fd

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-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.3-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 640113ddc943522aaf71294e3f2d24013b0edd659b7820621492c9ebd3a2fb0b
MD5 c23f7c4292fa8143a67af2b90d4f0a5e
BLAKE2b-256 614e9fe96e616730954dfc87d8d1f52cbe3e458484cbe7ac34f52cfec9da7c1c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-cp34-cp34m-win32.whl
  • Upload date:
  • Size: 997.2 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.3-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 b1b8e41da09a0c3ef0b3d4bb72da0dde2abebe583c1e8462973233fd5ad0235f
MD5 fa7f12546de9c1310e004cfa90e2477d
BLAKE2b-256 05e91ca624f39b7264886c448651747671606c3331aee1d0185bd5452126c617

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-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.3-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 4b5417dcd2999db0f5a891d54717cfaee33acc64f4772c4bc574d4ff95ed9d80
MD5 ce97004f4e159d07f4b1388024a7502a
BLAKE2b-256 c7676e6cc1ff49dc4a782b816f9f28904939dec5c97a4691d2b664d469c6772c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.3-cp27-cp27m-win32.whl
  • Upload date:
  • Size: 990.1 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.3-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 2315e7f104681d498ccf6fd70b0dba5bce65d60ac92171492bfe228e21dcc242
MD5 71200da307cbeeffa69c135f16a5a2e2
BLAKE2b-256 2bc78875bbe479ddd6f55764ba243abc4c348ee0924a90a48a6abe7620b2cb61

See more details on using hashes here.

Supported by

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