将数据复制（导入）到PostgreSQL数组列中

Question

一个 (CSV?) 文本文件应该如何格式化，才能用 COPY 导入到 PostgreSQL (8.4) 表中的数组列中？

假设有表 testarray:

 Column  |          Type           |
---------+-------------------------|
 rundate | date                    | 
 runtype | integer                 | 
 raw     | double precision[]      | 
 labels  | character varying(16)[] | 
 results | double precision[]      | 
 outcome | character varying(8)[]  | 

并且

COPY testarray from '/tmp/import.txt' CSV

import.txt文件中以下两种内容都不起作用：

2010/06/22,88,{{1,2},{3,4}},{{1,2},{3,4}},{{1,2},{3,4}},{{1,2},{3,4}}
2010/06/22,88,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4
2010/06/22,88,'{{1,2},{3,4}}','{{1,2},{3,4}}','{{1,2},{3,4}}','{{1,2},{3,4}}'
2010/06/22,88,'1,2,3,4','1,2,3,4','1,2,3,4','1,2,3,4'

- SabreWolfy

Answer 1

COPY testarray from '/tmp/import.txt' CSV

2010-06-22,88,"{{1,2},{3,4}}","{{1,2},{3,4}}","{{1,2},{3,4}}","{{1,2},{3,4}}"

- Clodoaldo Neto

---

请注意，这是默认格式，但您可以选择覆盖默认引号字符。http://www.postgresql.org/docs/8.4/interactive/sql-copy.html - kgrittn