human
psycopg2: insert multiple rows with one query
assistant
Here is some code to execute sql query 'INSERT INTO table VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)' with all parameters in list `tup`

cur.executemany('INSERT INTO table VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)', tup)

#Warning: this code generation is experimental. Please inspect the code for any bugs before executing.