1 Answer
- Newest
- Most votes
- Most comments
0
Redshift is interpreting the backslash as an escape since you have specified ESCAPE in your COPY.
You can try:
- Remove
ESCAPEif it is not really needed. - Specify a different escape character https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html#copy-escape
- Use the CSV format reader https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-format.html#copy-csv
answered 5 years ago
Relevant content
- asked 4 years ago
