pg8000

Installation

Native API Interactive Examples

Basic Example

Transactions

Query Using Functions

Interval Type

Point Type

Client Encoding

JSON

Retrieve Column Metadata From Results

Notices And Notifications

Parameter Statuses

LIMIT ALL

IN and NOT IN

Many SQL Statements Can't Be Parameterized

COPY FROM And TO A Stream

Execute Multiple SQL Statements

Quoted Identifiers in SQL

Custom adapter from a Python type to a PostgreSQL type

Custom adapter from a PostgreSQL type to a Python type

Could Not Determine Data Type Of Parameter

Prepared Statements

Use Environment Variables As Connection Defaults

Connect To PostgreSQL Over SSL

Server-Side Cursors

BLOBs (Binary Large Objects)

Replication Protocol

DB-API 2 Interactive Examples

Basic Example

Query Using Functions

Interval Type

Point Type

Numeric Parameter Style

Autocommit

Client Encoding

JSON

Retrieve Column Names From Results

COPY from and to a file

Server-Side Cursors

BLOBs (Binary Large Objects)

Parameter Limit

Type Mapping

Theory Of Operation

Native API Docs

pg8000.native.Error

pg8000.native.InterfaceError

pg8000.native.DatabaseError

pg8000.native.Connection(user, host='localhost', database=None, port=5432, password=None, source\address=None, unix\sock=None, ssl\context=None, timeout=None, tcp\keepalive=True, application\name=None, replication=None, sock=None)

pg8000.native.Connection.notifications

pg8000.native.Connection.notices

pg8000.native.Connection.parameter\statuses

pg8000.native.Connection.run(sql, stream=None, types=None, \\kwargs)

pg8000.native.Connection.row\count

pg8000.native.Connection.columns

pg8000.native.Connection.close()

pg8000.native.Connection.register\out\adapter(typ, out\func)

pg8000.native.Connection.register\in\adapter(oid, in\func)

pg8000.native.Connection.prepare(sql)

pg8000.native.PreparedStatement

pg8000.native.PreparedStatement.run(\\kwargs)

pg8000.native.PreparedStatement.close()

pg8000.native.identifier(ident)

pg8000.native.literal(value)

DB-API 2 Docs

Properties

pg8000.dbapi.apilevel

pg8000.dbapi.threadsafety

pg8000.dbapi.paramstyle

pg8000.dbapi.STRING

pg8000.dbapi.BINARY

pg8000.dbapi.NUMBER

pg8000.dbapi.DATETIME

pg8000.dbapi.ROWID

Functions

pg8000.dbapi.connect(user, host='localhost', database=None, port=5432, password=None, source\address=None, unix\sock=None, ssl\context=None, timeout=None, tcp\keepalive=True, applicationaname=None, replication=None, sock=None)

pg8000.dbapi.Date(year, month, day)

pg8000.dbapi.Time(hour, minute, second)

pg8000.dbapi.Timestamp(year, month, day, hour, minute, second)

pg8000.dbapi.DateFromTicks(ticks)

pg8000.dbapi.TimeFromTicks(ticks)

pg8000.dbapi.TimestampFromTicks(ticks)

pg8000.dbapi.Binary(value)

Generic Exceptions

pg8000.dbapi.Warning

pg8000.dbapi.Error

pg8000.dbapi.InterfaceError

pg8000.dbapi.DatabaseError

pg8000.dbapi.DataError

pg8000.dbapi.OperationalError

pg8000.dbapi.IntegrityError

pg8000.dbapi.InternalError

pg8000.dbapi.ProgrammingError

pg8000.dbapi.NotSupportedError

Classes

pg8000.dbapi.Connection

pg8000.dbapi.Connection.autocommit

pg8000.dbapi.Connection.close()

pg8000.dbapi.Connection.cursor()

pg8000.dbapi.Connection.rollback()

pg8000.dbapi.Connection.tpcbegin(xid)

pg8000.dbapi.Connection.tpccommit(xid=None)

pg8000.dbapi.Connection.tpcprepare()

pg8000.dbapi.Connection.tpcrecover()

pg8000.dbapi.Connection.tpcrollback(xid=None)

pg8000.dbapi.Connection.xid(formatid, globaltransactionid, branchqualifier)

pg8000.dbapi.Cursor

pg8000.dbapi.Cursor.arraysize

pg8000.dbapi.Cursor.connection

pg8000.dbapi.Cursor.rowcount

pg8000.dbapi.Cursor.description

pg8000.dbapi.Cursor.close()

pg8000.dbapi.Cursor.execute(operation, args=None, stream=None)

pg8000.dbapi.Cursor.executemany(operation, paramsets)

pg8000.dbapi.Cursor.callproc(procname, parameters=None)

pg8000.dbapi.Cursor.fetchall()

pg8000.dbapi.Cursor.fetchmany(size=None)

pg8000.dbapi.Cursor.fetchone()

pg8000.dbapi.Cursor.setinputsizes(\sizes)

pg8000.dbapi.Cursor.setoutputsize(size, column=None)

pg8000.dbapi.Interval

Design Decisions

Tests

Doing A Release Of pg8000

Release Notes

Version 1.31.2, 2024-04-28

Version 1.31.1, 2024-04-01

Version 1.31.0, 2024-03-31

Version 1.30.5, 2024-02-22

Version 1.30.4, 2024-01-03

Version 1.30.3, 2023-10-31

Version 1.30.2, 2023-09-17

Version 1.30.1, 2023-07-29

Version 1.30.0, 2023-07-27

Version 1.29.8, 2023-06-16

Version 1.29.7, 2023-06-16

Version 1.29.6, 2023-05-29

Version 1.29.5, 2023-05-09

Version 1.29.4, 2022-12-14

Version 1.29.3, 2022-10-26

Version 1.29.2, 2022-10-09

Version 1.29.1, 2022-05-23

Version 1.29.0, 2022-05-21

Version 1.28.3, 2022-05-18

Version 1.28.2, 2022-05-17

Version 1.28.1, 2022-05-17

Version 1.28.0, 2022-05-17

Version 1.27.1, 2022-05-16

Version 1.27.0, 2022-05-16

Version 1.26.1, 2022-04-23

Version 1.26.0, 2022-04-18

Version 1.25.0, 2022-04-17

Version 1.24.2, 2022-04-15

Version 1.24.1, 2022-03-02

Version 1.24.0, 2022-02-06

Version 1.23.0, 2021-11-13

Version 1.22.1, 2021-11-10

Version 1.22.0, 2021-10-13