python postgresql跨数据库操作,使用Python将INSERT与PostgreSQL数据库结合使用

I am trying to insert data into a PostgreSQL database table using Python. I don't see any syntax errors but, for some reason, my data isn't getting inserted into the database.

conn = psycopg2.connect(connection)

cursor = conn.cursor()

items = pickle.load(open(pickle_file,"rb"))

for item in items:

city = item[0]

price = item[1]

info = item[2]

query = "INSERT INTO items (info, city, price) VALUES (%s, %s, %s);"

data = (info, city, price)

cursor.execute(query, data)

解决方案

You have to commit the transaction.

conn.commit()

If there's no reason to think the transaction will fail, it's faster to commit after the for loop finishes.