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

Uploaded Source

Built Distributions

psycopg2-2.8.1-cp37-cp37m-win_amd64.whl (912.7 kB view details)

Uploaded CPython 3.7mWindows x86-64

psycopg2-2.8.1-cp37-cp37m-win32.whl (769.2 kB view details)

Uploaded CPython 3.7mWindows x86

psycopg2-2.8.1-cp36-cp36m-win_amd64.whl (912.7 kB view details)

Uploaded CPython 3.6mWindows x86-64

psycopg2-2.8.1-cp36-cp36m-win32.whl (769.2 kB view details)

Uploaded CPython 3.6mWindows x86

psycopg2-2.8.1-cp35-cp35m-win_amd64.whl (912.7 kB view details)

Uploaded CPython 3.5mWindows x86-64

psycopg2-2.8.1-cp35-cp35m-win32.whl (769.2 kB view details)

Uploaded CPython 3.5mWindows x86

psycopg2-2.8.1-cp34-cp34m-win_amd64.whl (902.7 kB view details)

Uploaded CPython 3.4mWindows x86-64

psycopg2-2.8.1-cp34-cp34m-win32.whl (780.0 kB view details)

Uploaded CPython 3.4mWindows x86

psycopg2-2.8.1-cp27-cp27m-win_amd64.whl (905.2 kB view details)

Uploaded CPython 2.7mWindows x86-64

psycopg2-2.8.1-cp27-cp27m-win32.whl (775.7 kB view details)

Uploaded CPython 2.7mWindows x86

File details

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

File metadata

  • Download URL: psycopg2-2.8.1.tar.gz
  • Upload date:
  • Size: 368.0 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.1.tar.gz
Algorithm Hash digest
SHA256 b4a475ce87eabc0607e068a3c704d0aa0820237ed78d493b8e2d880eb73cd7fe
MD5 bc46e48e09aa843957b70df96df2f215
BLAKE2b-256 52bef898e712f5f08131d651a62754fca82a1deb42e4e9889ad01932f770a2be

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 912.7 kB
  • 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.1-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 8af13498e32a00d0a66e43b7491c15231b27ab964ee4d2277a4a2dbadfb2c482
MD5 f0793c52fc9fe1a3ddd1569b851021fd
BLAKE2b-256 a8242fa013100f7983b8e5a311a5b8f67194761e86318d7e92b4edf17b84c225

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 769.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.1-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 c49d66e97affdc80d084b3b363f09f17db621418f0b8e0524b06c54959e2094d
MD5 061b28387b367f2cd129624ec2cb5aec
BLAKE2b-256 9ba9fc9b0544135f219ae86f09dcd1ce8135c2f3aa7567a7b983e153c58bbf2d

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp36-cp36m-win_amd64.whl
  • Upload date:
  • Size: 912.7 kB
  • 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.1-cp36-cp36m-win_amd64.whl
Algorithm Hash digest
SHA256 3648afc2b4828a6e00d516d2d09a260edd2c1e3de1e0d41d99c5ab004a73d180
MD5 7827a213ad95d17e13373591388202ed
BLAKE2b-256 1bcc3fff8c75d882a50955311eaac9040615b7e699de3b9b8e45730ca653ce3b

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp36-cp36m-win32.whl
  • Upload date:
  • Size: 769.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.1-cp36-cp36m-win32.whl
Algorithm Hash digest
SHA256 a17bfc9faffcca0ad9360c1ad97ab61ede583aa954715e8e436ffd80046661ff
MD5 d7ab3c8d6f9c51c003808833a1682567
BLAKE2b-256 2ede343185c41af149dec3ef9f51ab282c4a142a26466891af39717d2575e65f

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp35-cp35m-win_amd64.whl
  • Upload date:
  • Size: 912.7 kB
  • 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.1-cp35-cp35m-win_amd64.whl
Algorithm Hash digest
SHA256 7c1ae1669d11105a002f804bebd7432f8dc7473459aa405164c6b44a922decd5
MD5 73b15ced8313895c0ecf70a4775e3239
BLAKE2b-256 b49fc4518ecba7644c7582a5be89b2f64ac281c0d4bc6795ddfce07f5f1fe4c0

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp35-cp35m-win32.whl
  • Upload date:
  • Size: 769.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.1-cp35-cp35m-win32.whl
Algorithm Hash digest
SHA256 e67d60cb1a32f5fd8fcea935cf9efb1d1c26f96203b0ca2ae98c4c40ef8d8eac
MD5 2c4e2ad0a6adee90631223dfd8050f60
BLAKE2b-256 73fbebba9026a7d34b2365582da682ada099a5662e5ab2ed4ac7d78d0216b519

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp34-cp34m-win_amd64.whl
  • Upload date:
  • Size: 902.7 kB
  • 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.1-cp34-cp34m-win_amd64.whl
Algorithm Hash digest
SHA256 d13fbc3d533656cfdf094e13c1b0f40917b72813755ba780971ba0ce04280ac4
MD5 b33df1b1ee1148d5cb566e82183de587
BLAKE2b-256 e457e6805e39af20260df058c7f7fece34685cc67367c8aca8fef3e59d499743

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp34-cp34m-win32.whl
  • Upload date:
  • Size: 780.0 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.1-cp34-cp34m-win32.whl
Algorithm Hash digest
SHA256 e1e4fe6e8ab9f9c7d28514d007f623999d2dd6b5b81069dd4f9d30dbdd6f7069
MD5 bcb3cea4c35caaf6486d95eeaf6b18fc
BLAKE2b-256 e0be352ff3f580a58bb744bf1c73bf73451168bba3a96bd70c83146cee9ce768

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp27-cp27m-win_amd64.whl
  • Upload date:
  • Size: 905.2 kB
  • 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.1-cp27-cp27m-win_amd64.whl
Algorithm Hash digest
SHA256 5329b4530e31f58e0eafc55e26bbef684509bcc3be41604e45c0b98c297dc722
MD5 2f1c0afd50a8fcc606966c211a2b3637
BLAKE2b-256 0c693db8183421415a2d665e63a9b0ff8fbb8ad295c5646e0b31ede1f9ef57bd

See more details on using hashes here.

File details

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

File metadata

  • Download URL: psycopg2-2.8.1-cp27-cp27m-win32.whl
  • Upload date:
  • Size: 775.7 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.1-cp27-cp27m-win32.whl
Algorithm Hash digest
SHA256 9d5489867bd5f6d6c6191a4debd8de9a5c03a9608cce3f4d7133e29e6bd4ec27
MD5 d730bc18c4c7d4a5245696376e945854
BLAKE2b-256 9895f83b00d528c3a63e3cc4ce1fc78abe082caa2ef8963cb5d832145a41fb45

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