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

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

Uploaded Source

Built Distributions

psycopg2-2.7.4-cp36-cp36m-win_amd64.whl (996.4 kB view details)

Uploaded CPython 3.6mWindows x86-64

psycopg2-2.7.4-cp36-cp36m-win32.whl (853.7 kB view details)

Uploaded CPython 3.6mWindows x86

psycopg2-2.7.4-cp36-cp36m-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 3.6m

psycopg2-2.7.4-cp36-cp36m-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 3.6m

psycopg2-2.7.4-cp36-cp36m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.7 MB view details)

Uploaded CPython 3.6mmacOS 10.10+ Intel (x86-64, i386)macOS 10.10+ x86-64macOS 10.6+ Intel (x86-64, i386)macOS 10.9+ Intel (x86-64, i386)macOS 10.9+ x86-64

psycopg2-2.7.4-cp35-cp35m-win_amd64.whl (996.5 kB view details)

Uploaded CPython 3.5mWindows x86-64

psycopg2-2.7.4-cp35-cp35m-win32.whl (853.7 kB view details)

Uploaded CPython 3.5mWindows x86

psycopg2-2.7.4-cp35-cp35m-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 3.5m

psycopg2-2.7.4-cp35-cp35m-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 3.5m

psycopg2-2.7.4-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.7 MB view details)

Uploaded CPython 3.5mmacOS 10.10+ Intel (x86-64, i386)macOS 10.10+ x86-64macOS 10.6+ Intel (x86-64, i386)macOS 10.9+ Intel (x86-64, i386)macOS 10.9+ x86-64

psycopg2-2.7.4-cp34-cp34m-win_amd64.whl (988.1 kB view details)

Uploaded CPython 3.4mWindows x86-64

psycopg2-2.7.4-cp34-cp34m-win32.whl (866.2 kB view details)

Uploaded CPython 3.4mWindows x86

psycopg2-2.7.4-cp34-cp34m-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 3.4m

psycopg2-2.7.4-cp34-cp34m-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 3.4m

psycopg2-2.7.4-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.7 MB view details)

Uploaded CPython 3.4mmacOS 10.10+ Intel (x86-64, i386)macOS 10.10+ x86-64macOS 10.6+ Intel (x86-64, i386)macOS 10.9+ Intel (x86-64, i386)macOS 10.9+ x86-64

psycopg2-2.7.4-cp33-cp33m-win_amd64.whl (988.3 kB view details)

Uploaded CPython 3.3mWindows x86-64

psycopg2-2.7.4-cp33-cp33m-win32.whl (866.3 kB view details)

Uploaded CPython 3.3mWindows x86

psycopg2-2.7.4-cp33-cp33m-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 3.3m

psycopg2-2.7.4-cp33-cp33m-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 3.3m

psycopg2-2.7.4-cp27-cp27mu-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 2.7mu

psycopg2-2.7.4-cp27-cp27mu-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 2.7mu

psycopg2-2.7.4-cp27-cp27m-win_amd64.whl (990.5 kB view details)

Uploaded CPython 2.7mWindows x86-64

psycopg2-2.7.4-cp27-cp27m-win32.whl (859.6 kB view details)

Uploaded CPython 2.7mWindows x86

psycopg2-2.7.4-cp27-cp27m-manylinux1_x86_64.whl (2.7 MB view details)

Uploaded CPython 2.7m

psycopg2-2.7.4-cp27-cp27m-manylinux1_i686.whl (2.4 MB view details)

Uploaded CPython 2.7m

psycopg2-2.7.4-cp27-cp27m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.7 MB view details)

Uploaded CPython 2.7mmacOS 10.10+ Intel (x86-64, i386)macOS 10.10+ x86-64macOS 10.6+ Intel (x86-64, i386)macOS 10.9+ Intel (x86-64, i386)macOS 10.9+ x86-64

File details

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

File metadata

  • Download URL: psycopg2-2.7.4.tar.gz
  • Upload date:
  • Size: 425.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for psycopg2-2.7.4.tar.gz
Algorithm Hash digest
SHA256 8bf51191d60f6987482ef0cfe8511bbf4877a5aa7f313d7b488b53189cf26209
MD5 70fc57072e084565a42689d416cf2c5c
BLAKE2b-256 748351580322ed0e82cba7ad8e0af590b8fb2cf11bd5aaa1ed872661bd36f462

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 8966829cb0d21a08a3c5ac971a2eb67c3927ae27c247300a8476554cc0ce2ae8
MD5 119eb3ab86ea8486ab10ef4ea3f67f15
BLAKE2b-256 f977e29b792740ddec37a2d49431efa6c707cf3869c0cc7f28c7411bb6e96d91

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 ad75fe10bea19ad2188c5cb5fc4cdf53ee808d9b44578c94a3cd1e9fc2beb656
MD5 6828aec17da0b40d5780cc34c386c018
BLAKE2b-256 00954c5d19affca312e1c06d4f88241ebc564bf5269addd191ec4962f0c93553

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp36-cp36m-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp36-cp36m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 733166464598c239323142c071fa4c9b91c14359176e5ae7e202db6bcc1d2eb5
MD5 8288ce1eedf0b70e5f1d8c982fad5a41
BLAKE2b-256 921592b5c363243376ce9cb879bbec561bba196694eb663a6937b4cb967e230e

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp36-cp36m-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp36-cp36m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 0b9851e798bae024ed1a2a6377a8dab4b8a128a56ed406f572f9f06194e4b275
MD5 93ae94285ff7d27e50cf00e8d53c4848
BLAKE2b-256 257eeb6d6b1b5e99440def358f45f852f5ac62d26c59fef043770c1d7404c402

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp36-cp36m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp36-cp36m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
Algorithm Hash digest
SHA256 b68e89bb086a9476fa85298caab43f92d0a6af135a5f433d1f6b6d82cafa7b55
MD5 1f2b2137c65dc50c16b341774cd822eb
BLAKE2b-256 8ca50e61d6f4a140a6e06a9ba40266c4b49123d834f1f97fe9a5ae0b6e45112b

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 27467fd5af1dcc0a82d72927113b8f92da8f44b2efbdb8906bd76face95b596d
MD5 fc850e2bf7dae6e40a18ad589c750193
BLAKE2b-256 f8b2b02bbede43cf45844f3303dd9fdf5c8720ca04f811b07ec7489e0be42467

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 8ebba5314c609a05c6955e5773c7e0e57b8dd817e4f751f30de729be58fa5e78
MD5 7602bce5cb8aa70b17c84e1ade215754
BLAKE2b-256 caab49f8ebecd7d03084215c5e63ad36f14e981872809cad4e64aa27271ce1c9

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp35-cp35m-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp35-cp35m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 8eb94c0625c529215b53c08fb4e461546e2f3fc96a49c13d5474b5ad7aeab6cf
MD5 76349e1b048a9c884b58a1727d745512
BLAKE2b-256 8a8697879021d5ca2e069ade58eb55da01a2ade6507bb31f565914f4df10a444

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp35-cp35m-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp35-cp35m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 32702e3bd8bfe12b36226ba9846ed9e22336fc4bd710039d594b36bd432ae255
MD5 47baf80a5261d60e8694b8ef9fb31d91
BLAKE2b-256 cb3e39f98d73666bb6790567404141ba7eea82d7e61ba2ac44c6b1a2ca1e3ae8

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
Algorithm Hash digest
SHA256 d74cf9234ba76426add5e123449be08993a9b13ff434c6efa3a07caa305a619f
MD5 b4005994b6c67e6d247ce7c9b07fd966
BLAKE2b-256 6b084f3f7982916ada6a1a15fad8ea5279cbaca22d5324b8ad0fb21f31925bd1

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 363fbbf4189722fc46779be1fad2597e2c40b3f577dc618f353a46391cf5d235
MD5 f54bd03069965c49cffebf7ff551f8ce
BLAKE2b-256 1d624b817f8546098d036f5eec016b62473644696b7c24ea6bf2545332d90f56

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 027ae518d0e3b8fff41990e598bc7774c3d08a3a20e9ecc0b59fb2aaaf152f7f
MD5 386fe1f1d491c5b3eac5b09378e0a9cf
BLAKE2b-256 2ab8dce82ffc6222ab1854a2b91bfdce0e527d451715ee7d85de419981e2bec6

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp34-cp34m-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp34-cp34m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 19983b77ec1fc2a210092aa0333ee48811fd9fb5f194c6cd5b927ed409aea5f8
MD5 b3a40d9adb69020896e7122bd80800bf
BLAKE2b-256 09e3d24dfd49b79813f3021116383fdd2f0380b8145ca0bfcb15c6a72072b8d3

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp34-cp34m-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp34-cp34m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 f3d3a88128f0c219bdc5b2d9ccd496517199660cea021c560a3252116df91cbd
MD5 8866a20f5684b2a6957c2f7dca2b1d37
BLAKE2b-256 4d3e088b6e6200f54811da33a3bc6bbdd14779a9e88941d5497b344e36ff4e0f

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
Algorithm Hash digest
SHA256 092a80da1b052a181b6e6c765849c9b32d46c5dac3b81bf8c9b83e697f3cdbe8
MD5 5262918a868d8d3acace3a3fa58df910
BLAKE2b-256 dd29fb5e60247714b076ae19d198ce660b5306f218d339c30cf8935299b634d4

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp33-cp33m-win_amd64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp33-cp33m-win_amd64.whl
Algorithm Hash digest
SHA256 33f9e1032095e1436fa9ec424abcbd4c170da934fb70e391c5d78275d0307c75
MD5 c34e55e60deece9cc5d5039c5be53a9e
BLAKE2b-256 265649faf643bea3916dce96d98313a4f60cdf79af3f6d79ff307ca6cbba0f99

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp33-cp33m-win32.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp33-cp33m-win32.whl
Algorithm Hash digest
SHA256 179c52eb870110a8c1b460c86d4f696d58510ea025602cd3f81453746fccb94f
MD5 0d688b1a99dd8a1d20de8665e786fcc2
BLAKE2b-256 fce1198f42b46cd6218ccd8a07c3dcf5a37f5ad9e696ba898f3bde57140768dd

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp33-cp33m-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp33-cp33m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 932a4c101af007cb3132b1f8a9ffef23386acc53dad46536dc5ba43a3235ae02
MD5 58784b921c8f9a4a9398db0b2ff1c9b2
BLAKE2b-256 b25e5709c7590f5c44a46a64501fe0a8c86fe13f8cd1d9974b804b654d13294e

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp33-cp33m-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp33-cp33m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 888bba7841116e529f407f15c6d28fe3ef0760df8c45257442ec2f14f161c871
MD5 e7eb40b2e04bacf1489cfb5b83c96c1e
BLAKE2b-256 20d80164450526030b68535db1007bb6080d8eb62cc6be90888740868105909d

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp27-cp27mu-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27mu-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 b178e0923c93393e16646155794521e063ec17b7cc9f943f15b7d4b39776ea2c
MD5 db941253675d91c8cfc03d3e2e621668
BLAKE2b-256 7cc87cf31d2fd64b5cfa3f4538ee47f6dac6cfcaf647956e10a0c1617e68248f

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp27-cp27mu-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27mu-manylinux1_i686.whl
Algorithm Hash digest
SHA256 7cbc3b21ce2f681ca9ad2d8c0901090b23a30c955e980ebf1006d41f37068a95
MD5 ec049bbad9653a5f335bfc1f26148e40
BLAKE2b-256 99185e56ffe76c499733b0bef59952877c21d257508c4165333a36c2f230f7b5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 6f302c486132f8dd11f143e919e236ea4467d53bf18c451cac577e6988ecbd05
MD5 ff994fc7a60b162ce313d48b96bf5649
BLAKE2b-256 3e230162ee2c8aef91d75b44848a4203bb661207ba7d0ffa594db3968df250c5

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 fe6a7f87356116f5ea840c65b032af17deef0e1a5c34013a2962dd6f99b860dd
MD5 ad351a7a87a06b783b3c978fef6e584d
BLAKE2b-256 56721824e1c95891266ce07e424e75355a66c1ea824c40dbe6ef4dd07cb5a933

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp27-cp27m-manylinux1_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27m-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 36030ca7f4b4519ee4f52a74edc4ec73c75abfb6ea1d80ac7480953d1c0aa3c3
MD5 2f5340c794db24fbfc7c5013970491b9
BLAKE2b-256 755cee9b236e34ffc595992a08f375a3f907ddb67ee2a59d429f9ea97a8f21b8

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp27-cp27m-manylinux1_i686.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27m-manylinux1_i686.whl
Algorithm Hash digest
SHA256 1d90379d01d0dc50ae9b40c863933d87ff82d51dd7d52cea5d1cb7019afd72cd
MD5 56a2793777f11a3cfef484b3173f16c7
BLAKE2b-256 70073ca5755bfef823dbdb1b582b76163ba3cea2a2d7f39eec48f18ad3a2f132

See more details on using hashes here.

File details

Details for the file psycopg2-2.7.4-cp27-cp27m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl.

File metadata

File hashes

Hashes for psycopg2-2.7.4-cp27-cp27m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl
Algorithm Hash digest
SHA256 aeaba399254ca79c299d9fe6aa811d3c3eac61458dee10270de7f4e71c624998
MD5 1cb4fdd92285b3f197177b1adf6eeac1
BLAKE2b-256 67ee668612acf12fecb8f8a19342517b8c4cf172b7bb9ff9fa1f86e7f95a4757

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