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





All Articles