Maybe this question was discussed previously, but I could not find an answer:
An application used PQntuples function to obtain number of tuples after executing each query. Since number of rows increased we decided to use DECLARE CURSOR/FETCH commands to retrieve tuples. However, it seems that number of the tuples is not available after DECLARE CURSOR command. We want to minimize the changes in the app. *Is it possible to obtain number of rows that a cursor will return?* Thank you Konstantin