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