Load Data Enclosed By and Embedded With Double Quotes
Jim Knicely, Vertica Principal Solution Architect
September 4, 2019
Loading string data that is enclosed in double quotes where the string also contains double quotes can be problematic. We could alter the data so that it includes an escape character prior to each embedded double quote, but maybe that’s not possible. Another solution would be to use a FILLER to load the data then...