Iterating on a page returning execute_values
http://initd.org/psycopg/docs/extras.html
psycopg2.extras.execute_values ββhas parameters page_size
. I do INSERT INTO... ON CONFLICT...
with RETURNING ID
.
The problem is that cursor.fetchall()
it only returns the last "page" to me, ie 100 IDs (default page_size
).
Without changing the parameters page_size
, is it possible to iterate over the results to get the total number of rows?
+3
source to share
No one has answered this question yet
Check out similar questions: