---
id: pg8000
version: "1.31.5"
license: BSD 3-Clause License
license_treatment: permissive
maintenance: aging
---

# pg8000 — PostgreSQL interface library

License: permissive · Maintenance: aging · Popularity: top 1,000 on PyPI

## Install

pip install pg8000
uv add pg8000
poetry add pg8000

## Description

# pg8000

pg8000 is a pure-[Python](https://www.python.org/)
[PostgreSQL](http://www.postgresql.org/) driver that complies with
[DB-API 2.0](http://www.python.org/dev/peps/pep-0249/). pg8000's name comes from the
belief that it is probably about the 8000th PostgreSQL interface for Python. pg8000 is
distributed under the BSD 3-clause license.

<!-- mtoc-start -->

* [Installation](#installation)
* [Native API Interactive Examples](#native-api-interactive-examples)
  * [Basic Example](#basic-example)
  * [Transactions](#transactions)
  * [Query Using Functions](#query-using-functions)
  * [Interval Type](#interval-type)
  * [Point Type](#point-type)
  * [Client Encoding](#client-encoding)
  * [JSON](#json)
  * [Retrieve Column Metadata From Results](#retrieve-column-metadata-from-results)
  * [Notices And Notifications](#notices-and-notifications)
  * [Parameter Statuses](#parameter-statuses)
  * [LIMIT ALL](#limit-all)
  * [IN and NOT IN](#in-and-not-in)
  * [Many SQL Statements Can't Be Parameterized](#many-sql-statements-cant-be-parameterized)
  * [COPY FROM And TO A Stream](#copy-from-and-to-a-stream)
  * [Execute Multiple SQL Statements](#execute-multiple-sql-statements)
  *...

## AI interpretation — verify before relying

pg8000 is a pure-Python PostgreSQL driver that implements the DB-API 2.0 standard, enabling Python applications to connect to and query PostgreSQL databases without compiled dependencies.

Verdict: pg8000 is a stable, permissively licensed PostgreSQL driver suitable for Python 3.9+ applications that need DB-API 2.0 compliance without compiled dependencies. Low install friction and no known vulnerabilities make it a reliable choice, though its aging status (333 days since release) means you should verify compatibility with your specific PostgreSQL version before adoption.

[View on SkillFed](https://skillfed.io/packages/pg8000) · [View on PyPI](https://pypi.org/project/pg8000/)