psycopg2 - Python-PostgreSQL Database Adapter

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for jerickso from gravatar.com jerickso Avatar for piro from gravatar.com piro

Unverified details

These details have not been verified by PyPI
Project links
Meta
Classifiers

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

Verified details

These details have been verified by PyPI
Maintainers
Avatar for jerickso from gravatar.com jerickso Avatar for piro from gravatar.com piro

Unverified details

These details have not been verified by PyPI
Project links
Meta
Classifiers

Release history Release notifications | RSS feed

2.9.10

This version

2.9.9

2.9.8

2.9.7

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9

2.8.6

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8

2.7.7

2.7.6.1

2.7.6

2.7.5

2.7.4

2.7.3.2

2.7.3.1

2.7.3

2.7.2

2.7.1

2.7

2.6.2

2.6.1

2.6

2.5.5

2.5.4

2.5.3

2.5.2

2.5.1

2.5

2.4.6

2.4.5

2.4.4

2.4.3

2.4.2

2.4.1

2.4

2.3.2

2.3.1

2.3.0

2.2.2

2.2.1

2.2.0

2.0.14

2.0.13

2.0.12

2.0.11

2.0.10

2.0.8

2.0.7

2.0.6

2.0.5.1

2.0.4

2.0.3

2.0.2

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

Uploaded Source

Built Distributions

psycopg2-2.9.9-cp312-cp312-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.12 Windows x86-64

psycopg2-2.9.9-cp312-cp312-win32.whl (1.0 MB view details)

Uploaded CPython 3.12 Windows x86

psycopg2-2.9.9-cp311-cp311-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.11 Windows x86-64

psycopg2-2.9.9-cp311-cp311-win32.whl (1.0 MB view details)

Uploaded CPython 3.11 Windows x86

psycopg2-2.9.9-cp310-cp310-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.10 Windows x86-64

psycopg2-2.9.9-cp310-cp310-win32.whl (1.0 MB view details)

Uploaded CPython 3.10 Windows x86

psycopg2-2.9.9-cp39-cp39-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.9 Windows x86-64

psycopg2-2.9.9-cp39-cp39-win32.whl (1.0 MB view details)

Uploaded CPython 3.9 Windows x86

psycopg2-2.9.9-cp38-cp38-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.8 Windows x86-64

psycopg2-2.9.9-cp38-cp38-win32.whl (1.0 MB view details)

Uploaded CPython 3.8 Windows x86

psycopg2-2.9.9-cp37-cp37m-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.7m Windows x86-64

psycopg2-2.9.9-cp37-cp37m-win32.whl (1.0 MB view details)

Uploaded CPython 3.7m Windows x86

File details

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

File metadata

  • Download URL: psycopg2-2.9.9.tar.gz
  • Upload date:
  • Size: 384.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9.tar.gz
Algorithm Hash digest
SHA256 d1454bde93fb1e224166811694d600e746430c006fbb031ea06ecc2ea41bf156
MD5 eae35fa97cdc92b910b706c720a257c7
BLAKE2b-256 c95edc6acaf46d78979d6b03458b7a1618a68e152a6776fce95daac5e0f0301b

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp312-cp312-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.12, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 a7653d00b732afb6fc597e29c50ad28087dcb4fbfb28e86092277a559ae4e693
MD5 aedbdeaeac6e657df7095005905c412f
BLAKE2b-256 584bc4a26e191882b60150bfcb639e416524ae7f8249ab7ee854fb5247f16c40

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp312-cp312-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp312-cp312-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.12, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 d735786acc7dd25815e89cc4ad529a43af779db2e25aa7c626de864127e5a024
MD5 b6abb41fd033d007345427dfa6846495
BLAKE2b-256 1313f74ffe6b6f58822e807c70391dc5679a53feb92ce119ccb8a6546c3fb893

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for psycopg2-2.9.9-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 121081ea2e76729acfb0673ff33755e8703d45e926e416cb59bae3a86c6a4981
MD5 f97d70b6f5ec15b5c1f4e12a52c68f5d
BLAKE2b-256 372c5133dd3183a3bd82371569f0dd783e6927672de7e671b278ce248810b7f7

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp311-cp311-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp311-cp311-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.11, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 ade01303ccf7ae12c356a5e10911c9e1c51136003a9a1d92f7aa9d010fb98372
MD5 5af137c2648576d23757e7fa6216bd59
BLAKE2b-256 912c1fc5b9d33cd248c548ba19f2cef8e89cabaafab9858a602868a592cdc1b0

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for psycopg2-2.9.9-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 426f9f29bde126913a20a96ff8ce7d73fd8a216cfb323b1f04da402d452853c3
MD5 9af0fe13c0bb4a55213cc610e387818e
BLAKE2b-256 bcbc6572dec6834e779668421e25f8812a872d978e241f85491a5e4dda606a98

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp310-cp310-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp310-cp310-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.10, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 38a8dcc6856f569068b47de286b472b7c473ac7977243593a288ebce0dc89516
MD5 5ae157e34661f699f6761e0c88b78f33
BLAKE2b-256 a2142767d963915f957c07f5d4c3d9c5c9a407415289f5cde90b82cb3e8c2a12

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 de80739447af31525feddeb8effd640782cf5998e1a4e9192ebdf829717e3913
MD5 33989a4f7a679273c38442ca628f9240
BLAKE2b-256 f8ecec73fe66d4317db006a38ebafbde02cb7e1d727ed65f5bbe54efb191d9e6

See more details on using hashes here.

Provenance

File details

Details for the file psycopg2-2.9.9-cp39-cp39-win32.whl.

File metadata

  • Download URL: psycopg2-2.9.9-cp39-cp39-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.9, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 c92811b2d4c9b6ea0285942b2e7cac98a59e166d59c588fe5cfe1eda58e72d59
MD5 bc10c9d09d4d06071905f4bb6bd60d0d
BLAKE2b-256 6ba85080c0e61a3b393a379ea2fa93402135c73baffcd5f08b9503e508aac116

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: psycopg2-2.9.9-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 bac58c024c9922c23550af2a581998624d6e02350f4ae9c5f0bc642c633a2d5e
MD5 f1163997087eb268191bb6c0400ac7c7
BLAKE2b-256 8ee8c439b378efc9f2d0fd1fd5f66b03cb9ed41423f179997a935f10374f3c0d

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: psycopg2-2.9.9-cp38-cp38-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.8, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 ff432630e510709564c01dafdbe996cb552e0b9f3f065eb89bdce5bd31fabf4c
MD5 e07da9d5ce68dd46ab8999a351bd560a
BLAKE2b-256 1f7886b90d30c4e02e88379184ade34c2fd4883a4d3e420cc3c0f6da2b8f3a9a

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: psycopg2-2.9.9-cp37-cp37m-win_amd64.whl
  • Upload date:
  • Size: 1.2 MB
  • Tags: CPython 3.7m, Windows x86-64
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 7e2dacf8b009a1c1e843b5213a87f7c544b2b042476ed7755be813eaf4e8347a
MD5 3528c225580d4e9a85895064f4158ef0
BLAKE2b-256 bea70a39176d369a8289191f3d327139cfb4923dcedcfd7105774e57996f63cd

See more details on using hashes here.

Provenance

File details

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

File metadata

  • Download URL: psycopg2-2.9.9-cp37-cp37m-win32.whl
  • Upload date:
  • Size: 1.0 MB
  • Tags: CPython 3.7m, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.10.12

File hashes

Hashes for psycopg2-2.9.9-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 5e0d98cade4f0e0304d7d6f25bbfbc5bd186e07b38eac65379309c4ca3193efa
MD5 d65beef361bc9bdea0bf0181fad99c4d
BLAKE2b-256 2b77ffeb9ac356b3d99d97ca681bf0d0aa74f6d1d8c2ce0d6c4f2f34e396dbc0

See more details on using hashes here.

Provenance

Supported by

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