COPY TO
with a delimiter 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.DELIMITER ‘delimiter'
: The Delimiter used in the exported CSV file.,
).COPY TO
command overwrites the CSV file if it already exists. ,
).
,
) as the delimiter for the customer
table, the expected output would be: