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