Using the COPY
command, we can control the columns in which the values need to be inserted for a table. Moreover, the COPY
command supports operators, constants, Nulls, and comments. It should be noted that the COPY
command cannot use the analytic and aggregate functions while loading the data, although it supports the following types of functions:
Date/time
Formatting
Numeric
String
Null handling
System information
You can also ignore columns from source files. For that, we need to use the FILLER
option.