Re: Returning SELECTed rows immediately instead of all at the end?

Ron <ronljohnsonjr@xxxxxxxxx> · Sat, 13 Jun 2020 06:34:52 -0500



    On 6/13/20 12:04 AM, David G. Johnston wrote:

    
      On Friday, June 12, 2020, Ron <ronljohnsonjr@xxxxxxxxx>
      wrote:

      
        I'm running amcheck on a set of indices (test machine, not prod)
        and want to track the progress.  Is there a SELECT clause that
        makes rows display as they are created,
      

      No
       
      or do I have
        to explicitly call bt_index_check() from a shell script or SQL
        function in order to see the output as each index is checked?

      
      You could wrap the function call in a custom plpgsql function
        (or just do a plpgsql loop) and side channel output via notice
        but i’d probably just do a shell script wrapper absent any other
        constraint.
    
    
    Yeah, a shell script was my next option.  Thanks.

    
    -- 

      Angular momentum makes the world go 'round.