How to get rowCount from result
Node pg returns the rowCount property of the result. https://node-postgres.com/api/result#properties
How do you get this value using pgtyped?
This is important for pagination.
My bad, I don't think rowCount can help with pagination. I'll still leave the issue open just in case anyone need the rowCount value for something.
Yes. This has been an inconvenient for me already as well. I think it would be very nice to be the less intrusive as possible on how the actual queries are executed.
Besides returning the full response, right now the generated code uses
export const QueryName = new PreparedQuery<IQueryNameParams,IQueryNameResult>(queryNameIR);
with PreparedQuery coming from @pgtyped/query. I haven't checked what PreparedQuery does, but it would be great to be able to run it through normal pool.client manually fo instance. Though I guess there might be some technical limitations to do that.