sql - 无法在 Postgresql 中加载 CSV 文件

Question

我是 PostgresSQL 的新手，我正在尝试加载以下格式的数据:

1,57000000000A,A,EN,0:01,male,hahaha,"Address is address",1234567,Not Applicable,,walk in and scream,papa,00:20:54,02:17:41,ABC,00:20:54,02:17:41,musical,farm,,cody,9,bad boy,,,,,X,,rest,,,musical is muscal,John Kotters ,,,2011-01-01

There are more than 10k records and some columns may have NULL data. When i try to do this:

COPY ane FROM 'C:/Program Files (x86)/PostgreSQL/8.4/csv-data/my-data.csv' WITH
DELIMITER ',';

我收到以下错误:错误:最后一个预期列之后的额外数据SQL状态:22P04

我检查了列，它们没问题。这意味着没有遗漏任何列。

希望有人能帮忙。提前致谢。

Answer 1

应该是

 COPY ane FROM 'C:/Program Files (x86)/PostgreSQL/8.4/csv-data/my-data.csv' WITH
 DELIMITER ',' CSV;

对我有用