I use the following to load data into postgres
\copy tab FROM /tmp/file DELIMITER E'\t' QUOTE E'\b' NULL AS '\N' CSV
Usually I select the data from a source db
echo "select * from tab" | mysql --batch --quick --skip-column-names .... > /tmp/file
It generates a file with tab delimiter fields. It works well for the most part. Up until I try to import multi line text column.
The error comes on:
ERROR: unquoted carriage return found in data
Any recommendations how to overcome this?
Asked by Nir
(529 rep)
Nov 22, 2020, 09:36 AM
Last activity: Nov 23, 2020, 01:56 PM
Last activity: Nov 23, 2020, 01:56 PM