psycopg2: insert multiple rows with one query

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I need to insert multiple rows with one query (number of rows is not constant), so I need to execute query like this one:

INSERT INTO t (a, b) VALUES (1, 2), (3, 4), (5, 6);

The only way I know is

args = [(1,2), (3,4), (5,6)]
args_str = ",".join(cursor.mogrify("%s", (x, )) for x in args)
cursor.execute("INSERT INTO t (a, b) VALUES "+args_str)

but I want some simpler way.

👻 Read also: what is the best laptop for engineering students?

We hope this article has helped you to resolve the problem. Apart from psycopg2: insert multiple rows with one query, check other code Python module-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano psycopg2: insert multiple rows with one query
• Deutsch psycopg2: insert multiple rows with one query
• Français psycopg2: insert multiple rows with one query
• Español psycopg2: insert multiple rows with one query
• Türk psycopg2: insert multiple rows with one query
• Русский psycopg2: insert multiple rows with one query
• Português psycopg2: insert multiple rows with one query
• Polski psycopg2: insert multiple rows with one query
• Nederlandse psycopg2: insert multiple rows with one query
• 中文 psycopg2: insert multiple rows with one query
• 한국어 psycopg2: insert multiple rows with one query
• 日本語 psycopg2: insert multiple rows with one query
• हिन्दी psycopg2: insert multiple rows with one query