COPY Option Parser Dependencies

The following table summarizes which COPY parameters are available when loading data using the default (DELIMITER), NATIVE (binary), NATIVE VARCHAR, and FIXEDWIDTH parsers:

COPY Option DELIMITER NATIVE (BINARY) NATIVE (VARCHAR) FIXEDWIDTH
COLUMN OPTION • • •

•

AUTO • • •

•

DIRECT • • •

•

TRICKLE • • •

•

ENFORCELENGTH • • •

•

EXCEPTIONS • • •

•

FILLER • • •

•

REJECTED DATA • • •

•

ABORT ON ERROR • • •

•

STREAM NAME • • •

•

SKIP • • •

•

SKIP BYTES

•

REJECTMAX • • •

•

STDIN • • •

•

UNCOMPRESSED • • •

•

BZIP
GZIP
• • •

•

CONCATENATED BZIPGZIP

•

•

NO COMMIT • • •

•

FORMAT • • •

•

NULL • • •

•

DELIMITED

•

ENCLOSED BY

•

ESCAPE AS

•

TRAILING NULLCOLS

•

RECORD TERMINATOR

•

•

TRIM

•