Tom Lane wrote:
> "Karen Hill" <karen_hill22@yahoo.com> writes:
> > -- Is there a way to know the total number of rows the cursor is
> > capable of traversing without using --count?
>
> If you want an accurate count, the only way is to traverse the cursor.
> Consider using MOVE FORWARD ALL and noting the rowcount, then MOVE
> BACKWARD ALL to reset the cursor (the latter at least should be
> reasonably cheap).
>
Cool. Quick question, how does one go about noting the rowcount?
Using the rowcount in get diagnostics or something else?
regards,
karen.