Can you use array data types w/ the COPY command?

Поиск
Список
Период
Сортировка
От Peter E. Chen
Тема Can you use array data types w/ the COPY command?
Дата
Msg-id JBEOIGCPFENBBBIKPPLCKEECCOAA.pchen3@jhmi.edu
обсуждение исходный текст
Ответы Re: Can you use array data types w/ the COPY command?
Список pgsql-general
Dear All,

Is there anyway to use the COPY command to bulkload a flat-file containing a
column of csv's into a table w/ an integer[] data type?  When I try this, I
get the following error:

"ERROR:  copy: line 1, array_in: Need to specify dimension"

The dimension is variable for each row in the column.

Thanks for any advice.

Sincerely,
Peter


В списке pgsql-general по дате отправления: