my bad. that was the wrong code, here is my code: from pysqlite2 import dbapi2 as sqlite con = sqlite.connect("ex1") cur = con.cursor() cur.execute("select * from tbl1") print cur.fetchall()