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.

Code Quality Rank: L3
Programming language: C
License: BSD with attribution
Tags: Database Drivers     PostgreSQL    

psycopg2 alternatives and related packages

Based on the "PostgreSQL" category

Do you think we are missing an alternative of psycopg2 or a related project?

Add another 'PostgreSQL' Package

psycopg2 Recommendations

There are no recommendations yet. Be the first to promote psycopg2!

Have you used psycopg2? Share your experience. Write a short recommendation and psycopg2, you and your project will be promoted on Awesome Python.
Recommend psycopg2

Recently added psycopg2 resources

Do you know of a useful tutorial, book or news relevant to psycopg2?
Be the first to add one!