OpenSessame Code

# -*- coding: utf-8 -*-
import psycopg

dsn = "host=localhost dbname=clocks user=mmaglis password=magliver"
conn = psycopg.connect(dsn)
curs=conn.cursor()
#curs.execute("insert into transactions values('54321', '123456789123'")
#conn.commit()
curs.execute("begin work;declare crs cursor for select * from transactions")
curs.execute("fetch 1 from crs")
print curs.fetchall()