如何在postgresql中导入csv/data

Question

Hy，我知道已经有人问了很多问题，但这有点不同。我有一个包含数百万条记录的csv文件。我尝试了以下命令从csv复制到我的表，即

copy "client_data" from '/home/mike/Desktop/client_data.txt' with delimiter ',' CSV;

但是由于csv中的数据不一致，即，问题出现了

下面的线路想要魅力

12/12/12 20:17:35,304000000,"123","1"
12/12/12 20:17:36,311000000,"123","2"
12/12/12 20:17:36,814000000,"123","2"
12/12/12 20:17:36,814000000,"123","2"
12/12/12 20:17:37,317000000,"123",".1"
12/12/12 20:17:38,863000000,"123","TS"
12/12/12 20:17:39,835000000,"123","2"
12/12/12 20:17:40,337000000,"123","1"

但是数百行是类似的

12/12/12 20:20:03,790000000,"123","1
{'""}__{""'}        /""'
(      $AMZA./)@FRIDI
{__}""'{__}     /)      (. ,,DON,,"

12/12/12 20:20:30,501000000,"123","INAM NIKALTA NHE HE KITNE SAWALO K JAWB DAY 
 /GA,':/,':/SK,':"

12/12/12 20:22:55,928000000,"123","PAKISTAN KI BUNYAAD 
2=QUAID-E-AZAM"
12/12/12 20:22:56,431000000,"123","QUIED E AZAM
MOHAMMAD ALI JINNAH
[KFK FEROZ]"

由于换行符、逗号、无效字符等原因无法解析。有什么方法可以有效地解析这些数据并将数据加载到postgres表中吗？

下面是的表格结构

create table "client_data" (
date_stamp text,
points bigint,
msisdn character varying(13),
data text
)
with (OIDS = false);
alter table "client_data" owner to postgres;

Answer 1

是否使用MySql导入选项，因为MySql有更复杂且相对容易的导入方法来导入数据。