👻 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
Rome | 2023-01-27
StackOverflow is always a bit confusing 😭 psycopg2: insert multiple rows with one query is not the only problem I encountered. Checked yesterday, it works!
Singapore | 2023-01-27
Python functions is always a bit confusing 😭 psycopg2: insert multiple rows with one query is not the only problem I encountered. Will get back tomorrow with feedback
Massachussetts | 2023-01-27
I was preparing for my coding interview, thanks for clarifying this - psycopg2: insert multiple rows with one query in Python is not the simplest one. Will use it in my bachelor thesis