--- title: PostgreSQL adapter for Python | daily.dev description: Psycopg 3, the popular PostgreSQL adapter for Python, has reached its first stable release. It is a complete rewrite of psycopg2 supporting Python 3.6-3.10 and... canonical: https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL adapter for Python | daily.dev og:description: Psycopg 3, the popular PostgreSQL adapter for Python, has reached its first stable release. It is a complete rewrite of psycopg2 supporting Python 3.6-3.10 and... og:url: https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr og:image: https://api.daily.dev/og/posts/r9ofpQcWr.png og:image:alt: PostgreSQL adapter for Python og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL adapter for Python **[Psycopg](https://daily.dev/sources/psycopg)** · 2 min read · 0 upvotes · 0 comments ## Summary Psycopg 3, the popular PostgreSQL adapter for Python, has reached its first stable release. It is a complete rewrite of psycopg2 supporting Python 3.6-3.10 and PostgreSQL 10-14, adding async support, statically typed code, row factories, transaction blocks, and PostGIS support. Installation instructions and a full feature list are available in the documentation, and the project is seeking sponsors for continued development. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What's new in Psycopg 3 compared to psycopg2? Psycopg 3 is a complete rewrite of psycopg2 that adds support for modern Python development techniques including async/await and statically typed code. It targets Python 3.6 through 3.10 and PostgreSQL 10 through 14, and introduces row factories, transaction block support, and PostGIS support contributed by the community. _Developers migrating from psycopg2 can track adapter changes like this one on daily.dev._ ### Does Psycopg 3 support async database access in Python? Yes, Psycopg 3 was rewritten to support async, alongside statically typed code, as part of its move to modern Python development techniques. This is one of the core differences from psycopg2, which did not offer native async support for PostgreSQL access. _Follow database driver updates like this on daily.dev when choosing async-ready tools for Python._ ## Similar posts on daily.dev - [PostgreSQL: Psycopg 3.3 released](https://daily.dev/posts/postgresql-psycopg-3-3-released-ewfhnirnz) · PostgreSQL · 1 upvotes · 0 comments --- Tags: [#python](https://daily.dev/tags/python), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"PostgreSQL adapter for Python","url":"https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr"},"datePublished":"2026-08-23T12:22:10.327Z","dateModified":"2026-08-23T12:47:48.904Z","description":"Psycopg 3, the popular PostgreSQL adapter for Python, has reached its first stable release. It is a complete rewrite of psycopg2 supporting Python 3.6-3.10 and...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Psycopg","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Psycopg","logo":"https://media.daily.dev/image/upload/s--5N-KNNWk--/f_auto,q_auto/v1787487485/logos/psycopg?_a=BAMAMicg0","url":"https://daily.dev/sources/psycopg"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,postgresql","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Psycopg","item":"https://daily.dev/sources/psycopg"},{"@type":"ListItem","position":3,"name":"PostgreSQL adapter for Python"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-r9ofpqcwr#faq","mainEntity":[{"@type":"Question","name":"What's new in Psycopg 3 compared to psycopg2?","acceptedAnswer":{"@type":"Answer","text":"Psycopg 3 is a complete rewrite of psycopg2 that adds support for modern Python development techniques including async/await and statically typed code. It targets Python 3.6 through 3.10 and PostgreSQL 10 through 14, and introduces row factories, transaction block support, and PostGIS support contributed by the community. Developers migrating from psycopg2 can track adapter changes like this one on daily.dev."}},{"@type":"Question","name":"Does Psycopg 3 support async database access in Python?","acceptedAnswer":{"@type":"Answer","text":"Yes, Psycopg 3 was rewritten to support async, alongside statically typed code, as part of its move to modern Python development techniques. This is one of the core differences from psycopg2, which did not offer native async support for PostgreSQL access. Follow database driver updates like this on daily.dev when choosing async-ready tools for Python."}}]} ```