Copy Interface for Error Tolerance

Availability

This feature is available since openGauss 1.0.0.

Introduction

Certain errors that occur during the copy process are imported to a specified error table without interrupting the process.

Benefits

Refine the copy function and improve the tolerance and robustness to common errors such as invalid formats.

Description

openGauss provides the encapsulated copy error tables for creating functions and allows users to specify error tolerance options when using the Copy From statement. In this way, errors related to parsing, data format, and character set during the execution of the Copy From statement are recorded in the error table instead of being reported and interrupted. Even if a small amount of data in the target file of Copy From is incorrect, the data can be imported to the database. You can locate and rectify the fault in the error table later.

Enhancements

None

Constraints

For details, see handling-import-errors.

Dependencies

None