babar.py
text/x-python
Filename: babar.py
Type: text/x-python
Part: 0
import psycopg
with psycopg.connect("dbname=postgres user=postgres port=5434 host=localhost") as conn:
conn.execute("SELECT * FROM foo ORDER BY a OFFSET %s LIMIT %s", [100000,2])
conn.execute("SELECT 1")
conn.close()