Skip to main content

Psycopg2 support for the Spans library

Project description

Psycospans brings support for Spans [1] to Psycopg2 [2]. The Spans library implements PostgreSQL’s range types [3] in pure Python.

from psycospans import connect

conn = connect("dbname=test")
cur = conn.cursor()

test_range = intrange(1, 10)
cur.execute("SELECT int4range(5, NULL), %s", (test_range,))

other_range, test_range_cmp = cur.fetchone()

test_range == test_range_cmp # True
other_range == intrange(5) # True

Requirements

Psycospans will only work with PostgreSQL 9.2 or later.

Installation

Psycospans exists on PyPI.

pip install psycospans

Documentation

For full doumentation please run pydoc psycospans from a shell.

Supported by

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