psycopg2

Files added late

2 files were added to this release more than 14 days after its initial publication. Inspect the release files before installing.

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:
Windows:

Metadata

Release files for psycopg2 2.8.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Files added late

2 files were uploaded more than 14 days after the first file in this release.

While project maintainers occasionally add legitimate files to an existing release, late additions can also indicate a security compromise.

We recommend inspecting the release files before installing.

Source distribution (sdist)

Source distribution for psycopg2 2.8.6
File	Size	Uploaded
psycopg2-2.8.6.tar.gz	383.8 kB	Sep 6, 2020	Details

Built distributions (wheels)

Table of built distributions (wheels) for psycopg2 2.8.6
File	Interpreter	ABI	Platform	Reset
psycopg2-2.8.6-cp39-cp39-win_amd64.whl 1.2 MB Nov 4, 2020	CPython 3.9	CPython 3.9	Windows x86-64	Details
psycopg2-2.8.6-cp39-cp39-win32.whl 1.0 MB Nov 4, 2020	CPython 3.9	CPython 3.9	Windows x86-32	Details
psycopg2-2.8.6-cp38-cp38-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 3.8	CPython 3.8	Windows x86-64	Details
psycopg2-2.8.6-cp38-cp38-win32.whl 987.3 kB Sep 6, 2020	CPython 3.8	CPython 3.8	Windows x86-32	Details
psycopg2-2.8.6-cp37-cp37m-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 3.7	CPython 3.7 pymalloc	Windows x86-64	Details
psycopg2-2.8.6-cp37-cp37m-win32.whl 984.8 kB Sep 6, 2020	CPython 3.7	CPython 3.7 pymalloc	Windows x86-32	Details
psycopg2-2.8.6-cp36-cp36m-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 3.6	CPython 3.6 pymalloc	Windows x86-64	Details
psycopg2-2.8.6-cp36-cp36m-win32.whl 984.8 kB Sep 6, 2020	CPython 3.6	CPython 3.6 pymalloc	Windows x86-32	Details
psycopg2-2.8.6-cp35-cp35m-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 3.5	CPython 3.5 pymalloc	Windows x86-64	Details
psycopg2-2.8.6-cp35-cp35m-win32.whl 984.7 kB Sep 6, 2020	CPython 3.5	CPython 3.5 pymalloc	Windows x86-32	Details
psycopg2-2.8.6-cp34-cp34m-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 3.4	CPython 3.4 pymalloc	Windows x86-64	Details
psycopg2-2.8.6-cp34-cp34m-win32.whl 1.0 MB Sep 6, 2020	CPython 3.4	CPython 3.4 pymalloc	Windows x86-32	Details
psycopg2-2.8.6-cp27-cp27m-win_amd64.whl 1.1 MB Sep 6, 2020	CPython 2.7	CPython 2.7 pymalloc	Windows x86-64	Details
psycopg2-2.8.6-cp27-cp27m-win32.whl 995.3 kB Sep 6, 2020	CPython 2.7	CPython 2.7 pymalloc	Windows x86-32	Details

Total release size: 15.3 MB

Release files / psycopg2-2.8.6.tar.gz

Download URL	psycopg2-2.8.6.tar.gz
Size	383.8 kB
Tags	Source
SHA-256 checksum How to use checksums	`fb23f6c71107c37fd667cb4ea363ddeb936b348bbd6449278eb92c189699f543`
BLAKE2b-256 checksum How to use checksums	`fdae98cb7a0cbb1d748ee547b058b14604bd0e9bf285a8e0cc5d148f8a8a952e`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp39-cp39-win_amd64.whl

File added late

This file was uploaded more than 14 days after the first file in this release.

While project maintainers occasionally add legitimate files to an existing release, late additions can also indicate a security compromise.

We recommend inspecting the release file before installing.

Download URL	psycopg2-2.8.6-cp39-cp39-win_amd64.whl
Size	1.2 MB
Tags	CPython 3.9 Windows x86-64
SHA-256 checksum How to use checksums	`d5062ae50b222da28253059880a871dc87e099c25cb68acf613d9d227413d6f7`
BLAKE2b-256 checksum How to use checksums	`d6ebba556d3d642fedf220e2e7e4f16085d6f1f0363a1670fc4b72a26f497c5c`
Upload date	Nov 4, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp39-cp39-win32.whl

File added late

This file was uploaded more than 14 days after the first file in this release.

While project maintainers occasionally add legitimate files to an existing release, late additions can also indicate a security compromise.

We recommend inspecting the release file before installing.

Download URL	psycopg2-2.8.6-cp39-cp39-win32.whl
Size	1.0 MB
Tags	CPython 3.9 Windows x86-32
SHA-256 checksum How to use checksums	`2c93d4d16933fea5bbacbe1aaf8fa8c1348740b2e50b3735d1b0bf8154cbf0f3`
BLAKE2b-256 checksum How to use checksums	`0013ce81fc492fb61f33e2dd247e638c4c8a2187c58864e61a04de8496429e6e`
Upload date	Nov 4, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp38-cp38-win_amd64.whl

Download URL	psycopg2-2.8.6-cp38-cp38-win_amd64.whl
Size	1.1 MB
Tags	CPython 3.8 Windows x86-64
SHA-256 checksum How to use checksums	`56007a226b8e95aa980ada7abdea6b40b75ce62a433bd27cec7a8178d57f4051`
BLAKE2b-256 checksum How to use checksums	`18354be44fc779e8c8a7aedc4b19bf91dcd476edabd471b4d7c82f216b5ba271`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp38-cp38-win32.whl

Download URL	psycopg2-2.8.6-cp38-cp38-win32.whl
Size	987.3 kB
Tags	CPython 3.8 Windows x86-32
SHA-256 checksum How to use checksums	`ad2fe8a37be669082e61fb001c185ffb58867fdbb3e7a6b0b0d2ffe232353a3e`
BLAKE2b-256 checksum How to use checksums	`6f8f89b52c494dfb7f4f4c251e310b78b49f204ce0386f28316a92413e0e60bf`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp37-cp37m-win_amd64.whl

Download URL	psycopg2-2.8.6-cp37-cp37m-win_amd64.whl
Size	1.1 MB
Tags	CPython 3.7 CPython 3.7 pymalloc Windows x86-64
SHA-256 checksum How to use checksums	`56fee7f818d032f802b8eed81ef0c1232b8b42390df189cab9cfa87573fe52c5`
BLAKE2b-256 checksum How to use checksums	`441fa6ae3527568bb9a3d49339beb630ede2dcb345c88cc3cdc2a6dfbb78110e`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp37-cp37m-win32.whl

Download URL	psycopg2-2.8.6-cp37-cp37m-win32.whl
Size	984.8 kB
Tags	CPython 3.7 CPython 3.7 pymalloc Windows x86-32
SHA-256 checksum How to use checksums	`6a3d9efb6f36f1fe6aa8dbb5af55e067db802502c55a9defa47c5a1dad41df84`
BLAKE2b-256 checksum How to use checksums	`e408c0ad8002f69d4d31a656ed1a865f6cc6b3b781f03b6525455e3a79281a94`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp36-cp36m-win_amd64.whl

Download URL	psycopg2-2.8.6-cp36-cp36m-win_amd64.whl
Size	1.1 MB
Tags	CPython 3.6 CPython 3.6 pymalloc Windows x86-64
SHA-256 checksum How to use checksums	`f974c96fca34ae9e4f49839ba6b78addf0346777b46c4da27a7bf54f48d3057d`
BLAKE2b-256 checksum How to use checksums	`fd09b6c3e8442db0342629d1c95e9c451d7ee0920f6c1152edcc0d4bd0ee7ade`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp36-cp36m-win32.whl

Download URL	psycopg2-2.8.6-cp36-cp36m-win32.whl
Size	984.8 kB
Tags	CPython 3.6 CPython 3.6 pymalloc Windows x86-32
SHA-256 checksum How to use checksums	`a49833abfdede8985ba3f3ec641f771cca215479f41523e99dace96d5b8cce2a`
BLAKE2b-256 checksum How to use checksums	`9f6fec0689612a630f2b34c734c3d8db40f9a385898dec14f49306ed73c2ecd5`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp35-cp35m-win_amd64.whl

Download URL	psycopg2-2.8.6-cp35-cp35m-win_amd64.whl
Size	1.1 MB
Tags	CPython 3.5 CPython 3.5 pymalloc Windows x86-64
SHA-256 checksum How to use checksums	`00195b5f6832dbf2876b8bf77f12bdce648224c89c880719c745b90515233301`
BLAKE2b-256 checksum How to use checksums	`e3a8aa3d862173bfcc2f7d4a00516c293bc1c660933b35909c4373025636f508`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp35-cp35m-win32.whl

Download URL	psycopg2-2.8.6-cp35-cp35m-win32.whl
Size	984.7 kB
Tags	CPython 3.5 CPython 3.5 pymalloc Windows x86-32
SHA-256 checksum How to use checksums	`26e7fd115a6db75267b325de0fba089b911a4a12ebd3d0b5e7acb7028bc46821`
BLAKE2b-256 checksum How to use checksums	`902453f39fde488210c09869ac6bade7cfefa982fe542197716b190bac826733`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp34-cp34m-win_amd64.whl

Download URL	psycopg2-2.8.6-cp34-cp34m-win_amd64.whl
Size	1.1 MB
Tags	CPython 3.4 CPython 3.4 pymalloc Windows x86-64
SHA-256 checksum How to use checksums	`f22ea9b67aea4f4a1718300908a2fb62b3e4276cf00bd829a97ab5894af42ea3`
BLAKE2b-256 checksum How to use checksums	`ecc072786579c3d8e87b9b602c32c633c36dc20e346bddbcc506b1085513f8f8`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp34-cp34m-win32.whl

Download URL	psycopg2-2.8.6-cp34-cp34m-win32.whl
Size	1.0 MB
Tags	CPython 3.4 CPython 3.4 pymalloc Windows x86-32
SHA-256 checksum How to use checksums	`b8cae8b2f022efa1f011cc753adb9cbadfa5a184431d09b273fb49b4167561ad`
BLAKE2b-256 checksum How to use checksums	`d514cf8f9edb6aa1a7eea9587ee446276974b3096b5abed63e28323ede746397`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp27-cp27m-win_amd64.whl

Download URL	psycopg2-2.8.6-cp27-cp27m-win_amd64.whl
Size	1.1 MB
Tags	CPython 2.7 CPython 2.7 pymalloc Windows x86-64
SHA-256 checksum How to use checksums	`d160744652e81c80627a909a0e808f3c6653a40af435744de037e3172cf277f5`
BLAKE2b-256 checksum How to use checksums	`bcc10bf0150848f600be3839b1ea01b037d6355e191486f04c6f3af4e75d1b38`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release files / psycopg2-2.8.6-cp27-cp27m-win32.whl

Download URL	psycopg2-2.8.6-cp27-cp27m-win32.whl
Size	995.3 kB
Tags	CPython 2.7 CPython 2.7 pymalloc Windows x86-32
SHA-256 checksum How to use checksums	`068115e13c70dc5982dfc00c5d70437fe37c014c808acce119b5448361c03725`
BLAKE2b-256 checksum How to use checksums	`f41fca233a88530fb2ad7b6fa291765a55ec9fb7573c454f576e55ac232b0252`
Upload date	Sep 6, 2020
Uploaded using Trusted Publishing? What is 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`

Release history Release notifications | RSS feed

2.9.13

Sep 9, 2026 7 release files

2.9.12

Apr 20, 2026 7 release files

2.9.11

Oct 10, 2025 7 release files

2.9.10

Oct 16, 2024 10 release files

2.9.9

Oct 3, 2023 13 release files

2.9.8

Sep 28, 2023 11 release files

2.9.7

Aug 5, 2023 11 release files

2.9.6

Apr 3, 2023 13 release files

2.9.5

Oct 25, 2022 13 release files

2.9.4

Oct 6, 2022 11 release files

2.9.3

Dec 29, 2021 11 release files

2.9.2

Nov 12, 2021 11 release files

2.9.1

Jun 17, 2021 11 release files

2.9

Jun 16, 2021 9 release files

This release

2.8.6 This release

Sep 6, 2020 15 release files

2.8.5

Apr 6, 2020 13 release files

2.8.4

Oct 20, 2019 13 release files

2.8.3

Jun 13, 2019 11 release files

2.8.2

Apr 14, 2019 11 release files

2.8.1

Apr 6, 2019 11 release files

2.8

Apr 4, 2019 11 release files

2.7.7

Jan 22, 2019 30 release files

2.7.6.1

Nov 11, 2018 30 release files

2.7.6

Nov 9, 2018 30 release files

2.7.5

Jun 17, 2018 30 release files

2.7.4

Feb 8, 2018 27 release files

2.7.3.2

Oct 24, 2017 31 release files

2.7.3.1

Aug 26, 2017 31 release files

2.7.3

Jul 24, 2017 31 release files

2.7.2

Jul 22, 2017 31 release files

2.7.1

Mar 13, 2017 31 release files

2.7

Mar 1, 2017 31 release files

2.6.2

Jul 7, 2016 15 release files

2.6.1

Jun 15, 2015 11 release files

2.6

Feb 9, 2015 1 release file

2.5.5

Feb 9, 2015 1 release file

2.5.4

Aug 30, 2014 1 release file

2.5.3

May 13, 2014 1 release file

2.5.2

Jan 7, 2014 1 release file

2.5.1

Jun 23, 2013 1 release file

2.5

Apr 7, 2013 1 release file

2.4.6

Dec 12, 2012 1 release file

2.4.5

Mar 29, 2012 1 release file

2.4.4

Dec 19, 2011 1 release file

2.4.3

Dec 12, 2011 1 release file

2.4.2

Jun 17, 2011 1 release file

2.4.1

May 11, 2011 1 release file

2.4

Feb 27, 2011 1 release file

2.3.2

Feb 18, 2011 1 release file

2.3.1

Dec 4, 2010 1 release file

2.3.0

Dec 1, 2010 1 release file

2.2.2

Jul 26, 2010 1 release file

2.2.1

Jul 26, 2010 1 release file

2.2.0

Jul 26, 2010 1 release file

2.0.14

Apr 16, 2010 1 release file

2.0.13

Apr 16, 2010 1 release file

2.0.12

Aug 16, 2009 1 release file

2.0.11

Jul 7, 2009 1 release file

2.0.10

Jul 7, 2009 1 release file

Feb 15, 2009

Feb 15, 2009

Feb 15, 2009

Dec 2, 2006

Sep 1, 2006

Sep 1, 2006

Jun 12, 2006

psycopg2 2.8.6

Documentation

Installation

Project links

Key dates

2 maintainers

Credits

License

Requires

Classifiers

Metadata

Project links

Key dates

2 maintainers

Credits

License

Requires

Classifiers

Release files for psycopg2 2.8.6

Files added late

Source distribution (sdist)

Built distributions (wheels)

Release files / psycopg2-2.8.6.tar.gz

Release files / psycopg2-2.8.6-cp39-cp39-win_amd64.whl

File added late

Release files / psycopg2-2.8.6-cp39-cp39-win32.whl

File added late

Release files / psycopg2-2.8.6-cp38-cp38-win_amd64.whl

Release files / psycopg2-2.8.6-cp38-cp38-win32.whl

Release files / psycopg2-2.8.6-cp37-cp37m-win_amd64.whl

Release files / psycopg2-2.8.6-cp37-cp37m-win32.whl

Release files / psycopg2-2.8.6-cp36-cp36m-win_amd64.whl

Release files / psycopg2-2.8.6-cp36-cp36m-win32.whl

Release files / psycopg2-2.8.6-cp35-cp35m-win_amd64.whl

Release files / psycopg2-2.8.6-cp35-cp35m-win32.whl

Release files / psycopg2-2.8.6-cp34-cp34m-win_amd64.whl

Release files / psycopg2-2.8.6-cp34-cp34m-win32.whl

Release files / psycopg2-2.8.6-cp27-cp27m-win_amd64.whl

Release files / psycopg2-2.8.6-cp27-cp27m-win32.whl

Release history Release notifications | RSS feed