CoPY command error and rowcount

Sreedhar1

How to handle errors for copy command (not the rejects/exceptions files) and is there any variable/table where the total rows loaded using copy command are stored. I checked load_streams table but the table was empty

SruthiA

Hi Sreedhar,

 

      Once you load the data using copy command, execute the following query to know the count of rows loaded successfully

 

select get_num_accepted_rows();

 

 

-Regards,

 Sruthi