COPY TO
command, you can include or skip the header. Oxla provides three options for handling headers: HEADER OFF
, HEADER ON
, and HEADER MATCH
.
COPY TO
with HEADER
is as follows:
table_name
: The table containing the data to be exported.file_path
: The CSV file location where the data will be saved.Header_Syntax
: The specified header options.HEADER
is not provided.COPY TO
with different header options:
personalinfo
file without considering the first row as a header.HEADER ON
option.