Hi hackers,
backslash-period (\.) as end-of-data marker.
The example below will raise an error for the line contains `\.`.
CREATE TABLE test (
id int,
name text,
dep text
)
Data in file "/tmp/data".
122,as\.d,adad
133,sa dad,adadad
Then execute
copy test from '/tmp/data' DELIMITER ',';
An
end-of-copy marker corrupt error will be raised.
This requires users to escape the end-of-data marker manually in their data.
Why we don't have a mechanism to define other characters as end-of-data marker?
Or there are other ways to avoid escape the end-of-data in data?
Regards,
Junfeng