我正在尝试导入此 CSV 文件：

HEADER
"{
  ""field1"": ""123"",""field2"": ""456""
}"
"{
  ""field1"": ""789"",""field2"": ""101""
}"

进入我的 Postgres 表。

但是，似乎 \copy my_table(my_text) from 'my_file.csv' 命令正在为文件的每一行创建一行。

这就是我得到的：

                       my_text
-----------------------------------------------------
 HEADER
 "{
   ""field1"": ""123"",""field2"": ""456""
 }"
 "{
   ""field1"": ""789"",""field2"": ""101""
 }"
(9 rows)

以及我的期望：

{""field1"": ""123"",""field2"": ""456""}
{""field1"": ""789"",""field2"": ""101""}
(2 rows)