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

Uploaded Source

Built Distributions

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

Uploaded CPython 3.8Windows x86-64

psycopg2-2.8.4-cp38-cp38-win32.whl (986.3 kB view details)

Uploaded CPython 3.8Windows x86

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

Uploaded CPython 3.7mWindows x86-64

psycopg2-2.8.4-cp37-cp37m-win32.whl (983.5 kB view details)

Uploaded CPython 3.7mWindows x86

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

Uploaded CPython 3.6mWindows x86-64

psycopg2-2.8.4-cp36-cp36m-win32.whl (983.5 kB view details)

Uploaded CPython 3.6mWindows x86

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

Uploaded CPython 3.5mWindows x86-64

psycopg2-2.8.4-cp35-cp35m-win32.whl (983.5 kB view details)

Uploaded CPython 3.5mWindows x86

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

Uploaded CPython 3.4mWindows x86-64

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

Uploaded CPython 3.4mWindows x86

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

Uploaded CPython 2.7mWindows x86-64

psycopg2-2.8.4-cp27-cp27m-win32.whl (993.9 kB view details)

Uploaded CPython 2.7mWindows x86

File details

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

File metadata

  • Download URL: psycopg2-2.8.4.tar.gz
  • Upload date:
  • Size: 377.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4.tar.gz
Algorithm Hash digest
SHA256 f898e5cc0a662a9e12bde6f931263a1bbd350cfb18e1d5336a12927851825bb6
MD5 dbb5a67dd57cfa905de37ab9678a92f6
BLAKE2b-256 84d76a93c99b5ba4d4d22daa3928b983cec66df4536ca50b22ce5dcac65e4e71

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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/1.15.0 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.4-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 92a07dfd4d7c325dd177548c4134052d4842222833576c8391aab6f74038fc3f
MD5 ba56c3493a9d66a12fa15e792803d62c
BLAKE2b-256 5f00c2f699fd5848ffaf30affc82c5dc8966dd783eac58af70045aecf0facf13

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp38-cp38-win32.whl
  • Upload date:
  • Size: 986.3 kB
  • Tags: CPython 3.8, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 4212ca404c4445dc5746c0d68db27d2cbfb87b523fe233dc84ecd24062e35677
MD5 14249413b8dee559f92a374946473f00
BLAKE2b-256 79ad327e9c1e09b91e57294eb9a38492fcb000f15c028a1b716714fee5be802e

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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.15.0 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.4-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 47fc642bf6f427805daf52d6e52619fe0637648fe27017062d898f3bf891419d
MD5 230d6bba8a087ada75c10e1f1716c5a7
BLAKE2b-256 1a85853f11abfccfd581b099e5ae5f2dd807cc2919745b13d14e565022fd821c

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 983.5 kB
  • Tags: CPython 3.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 8396be6e5ff844282d4d49b81631772f80dabae5658d432202faf101f5283b7c
MD5 edfceab5c1e642e589d12d1d10832013
BLAKE2b-256 e3d14bdda027f2ad83189915e340d3ac01a589424d1b554809046b42d406a375

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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.15.0 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.4-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 dca2d7203f0dfce8ea4b3efd668f8ea65cd2b35112638e488a4c12594015f67b
MD5 d16a8d59fa08cb8f1b5947d3a5b134d4
BLAKE2b-256 4ad9467aba4b587f97e4047b9ae8609f22dc01eea56eda92358089db89b729ef

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 983.5 kB
  • Tags: CPython 3.6m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 ed686e5926929887e2c7ae0a700e32c6129abb798b4ad2b846e933de21508151
MD5 0337492151dc0c8dbdedf092a80d5515
BLAKE2b-256 d1c089266a88ae31c3f61da761a2251560cdfa6fb627a7a33a8414a0786ae956

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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.15.0 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.4-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 965c4c93e33e6984d8031f74e51227bd755376a9df6993774fd5b6fb3288b1f4
MD5 22321a7d10820b091379d7995066a03e
BLAKE2b-256 ac1d52662e81398f3affd71f683ab49351c7caf9415aede762f514d664766d5d

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp35-cp35m-win32.whl
  • Upload date:
  • Size: 983.5 kB
  • Tags: CPython 3.5m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 ef6df7e14698e79c59c7ee7cf94cd62e5b869db369ed4b1b8f7b729ea825712a
MD5 ff68d4a950a2810c137da7d669a76fe1
BLAKE2b-256 6bd147ff82871866a2a5e4ae22d905afc3df0d7992aba85f3c583affebc238ea

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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.15.0 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.4-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 b0845e3bdd4aa18dc2f9b6fb78fbd3d9d371ad167fd6d1b7ad01c0a6cdad4fc6
MD5 f30e27c3ec6c40f62cd39da96dede52d
BLAKE2b-256 4629110f5328be7ea0a4fb61f6542c510d779abdb29040aca47749456193adf6

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp34-cp34m-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.4m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 9ab75e0b2820880ae24b7136c4d230383e07db014456a476d096591172569c38
MD5 524c7f276c80c3df65948b1b4f632bae
BLAKE2b-256 b1d2b61da4bfe058073ecf272bcbed08ab444c7a10465b6f700ab96b23ad5447

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-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.15.0 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.4-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 893c11064b347b24ecdd277a094413e1954f8a4e8cdaf7ffbe7ca3db87c103f0
MD5 72bd3e5e5cc2ca21f25f142a45e0e8ad
BLAKE2b-256 65afb92009fe794af5753737cbd63190b174751c4b2220aa15f6d25939430480

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.4-cp27-cp27m-win32.whl
  • Upload date:
  • Size: 993.9 kB
  • Tags: CPython 2.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 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.4-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 72772181d9bad1fa349792a1e7384dde56742c14af2b9986013eb94a240f005b
MD5 0dd43cccf0cfa609201618f0973803ff
BLAKE2b-256 60d2c3a1b2a4da1dcb9e4884abdc6ef64dfb3d142600bf344ac2b1ea8115d5ab

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