Sample Header Ad - 728x90

Load text column to postgres

2 votes
1 answer
961 views
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