What is the maximum number of records that can be retrieved by postgreSQL?

Question

When retrieving records using SELECT in postgres, what is maximum number of records that can be retrieved? Can it return a maximum of 10 million records at a single time if I wanted it too? Or can it only return a specific amount (ex. 5,000) in order to encourage using LIMIT and OFFSET?

Answer 1

There is no limit to the number of result rows in a query.

If your client collects the whole result in memory, that poses a limit, but most clients can be configured not to do that.