Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Loading "standard" CSV file with double quoted fields
How can I load a standard csv file with the copy command? The issue i have is with double quote enclosed fields. When double quote characters occur within the text of a field, it appears as two consecutive double quote characters. (e.g. col1,col2,"col3 ""quoted"" word might also have, commas",col4) I can't seem to find any combination of options to the copy command that will let me actually load this type of csv file. If quotes within quotes had simply been escaped with a backslash, this would be easy. But, this method of quoting is about as standard as it gets with csv files. (This is the standard defined in RFC 4180.) It would surprise me if there is no way to actually load a "standard" csv file.