How to read data from Postgres line by line without loading everything into memory?

Question

PostgreSQL

I found that when I make a query to the database using the PQexec C function, immediately after its execution, a large amount of memory is allocated for the result of the query.
How would I do data reading without loading the entire result into memory, but working with each line in turn?

Answer 1

cursor
www.postgresql.org/docs/9.2/static/plpgsql-cursors.html

Answer 2

In general, yes, the above answered.
You can also advise not to do select * from

Answer 3

Thank you.