pgAdmin 4: Data Ouput tab allows only 1000 rows

Question

I am using pgAdmin 4.5 on Mac. My Data Output tab shows only 1000 rows even though the selection shows No Limit (and offers no other option.) It seems that the default value is 1000 (from pgAdmin 4.5 doc) despite the option of No Limit is shown.

Is this a known bug and should I move to the latest version?

Thanks,

Answer 1

This looks like it might be a bug.

Changing / increasing the below parameter helps to get more data. It is located in the file config.py pgAdmin4/web folder

##########################################################################
# Number of records to fetch in one batch in query tool when query result
# set is large.
##########################################################################
ON_DEMAND_RECORD_COUNT = 1000