copying json data and backslashes

do $$

lines=[r'{"test" : "\r this data has a carriage return"}']

with open("/tmp/test1.json","w") as f:

    for line in lines:

        f.write(line.strip() + "\n")

$$ language plpython3u;

create temp table testing (data jsonb);

-- this works

insert into testing (data)

select l::jsonb

from pg_read_file('/tmp/test1.json') f,

lateral regexp_split_to_table(f,'\n') l where l <> '';

-- fails

copy testing (data) from '/tmp/test1.json';

-- works

copy testing (data) from program $c$ sed -e 's/\\r/\\\\u000a/g' /tmp/test1.json $c$;