Synopsis

COPYC[OMMIT] n

Controls the number of batches after which the COPY command commits changes to the database. Since the size of a batch is controlled by ARRAYSIZE, the number of rows copied before each commit will be ARRAYSIZE × n. If you set COPYCOMMIT to zero, COPY performs a commit only at the end of a copy operation. The default is 0.