How to quote arrays in postgres copy statement to inser into JSON field
JSON uses double quote &quot; to delimite keys and strings:
[{&quot;id&quot;: &quot;NfKA3&quot;, &quot;u&quot;: &quot;https://somewebsite.com&quot;}]

CSV uses double quote to escape double quotes &quot;&quot; means &quot;
1,&quot;some text here&quot;, 22, &quot;[{&quot;&quot;id&quot;&quot;: &quot;&quot;NfKA3&quot;&quot;, &quot;&quot;u&quot;&quot;: &quot;&quot;https://somewebsite.com&quot;&quot;}]&quot;

Look at: https://stackoverflow.com/questions/17808511/properly-escape-a-double-quote-in-csv