Copy Tabel ke HDD

DO $$
    Declare waktu VARCHAR;
    cur1 CURSOR for SELECT (NOW() :: DATE) as VARCHAR;
       
begin   
OPEN Cur1 ; 
Loop   
    FETCH  next from Cur1 INTO waktu;    
    EXIT WHEN NOT FOUND;
    COPY audittable.tbl_loggedtransactions TO 'D:/loggedtransactions_2.csv' DELIMITER ',' CSV;
end loop ;  
CLOSE Cur1; 
END $$;