Python-PostgreSQL psycopg2接口 - > executemany

import psycopg2

# Connect to the database
conn = psycopg2.connect(database="mydb", user="myuser", password="mypassword", host="localhost", port="5432")
cur = conn.cursor()

# Create the table
cur.execute("CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(255), age INTEGER)")

# Prepare the SQL statement
sql = "INSERT INTO users (name, age) VALUES (%s, %s)"

# Prepare the list of user data
users = [("Alice", 30), ("Bob", 25), ("Charlie", 35)]

# Execute the SQL statement for each user
cur.executemany(sql, users)

# Commit the changes and close the connection
conn.commit()
cur.close()
conn.close()