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
|
• | • | • |
• |
CONCATENATED BZIP GZIP
|
• |
• |
||
NO COMMIT
|
• | • | • |
• |
FORMAT
|
• | • | • |
• |
NULL
|
• | • | • |
• |
DELIMITED
|
• |
|||
ENCLOSED BY
|
• |
|||
ESCAPE AS
|
• |
|||
TRAILING NULLCOLS
|
• |
|||
RECORD TERMINATOR
|
• |
• |
||
TRIM
|
• |