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.