cells = row.findAll("th")
if len(cells) != 0:
    A.append(cells[0].find(text=True))
    B.append(cells[1].find(text=True))
    C.append(cells[2].find(text=True))

con = psycopg2.connect("host= 'localhost' dbname='testdb' user='postgres' password='root'")

cur = con.cursor()

cur.execute("CREATE TABLE test(id SERIAL INTEGER PRIMARY KEY, event_date TEXT, event_time VARCHAR)")

cur.execute("INSERT INTO test VALUES(%s)" % A, B, C)

con.commit()

con.rollback()

print 'Error %s' % e
sys.exit(1)

if con:

    con.close()