Tom Lane wrote: > "Karen Hill" <karen_hill22@xxxxxxxxx> 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.
