Using INSERT with a PostgreSQL Database using Python

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.