Postgres Pro
Downloads
Home   >   mailing lists

Can you use array data types w/ the COPY command? - Mailing list pgsql-general

From Peter E. Chen
Subject Can you use array data types w/ the COPY command?
Date
Msg-id JBEOIGCPFENBBBIKPPLCKEECCOAA.pchen3@jhmi.edu
Whole thread Raw
Responses Re: Can you use array data types w/ the COPY command?
List pgsql-general
Tree view 
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 by date:

Previous
From: will trillich
Date:
Subject: plperl functions -- can they call each other?
Next
From: "Terri Lerose"
Date:
Subject: [General] unsubscribe "Terri.Lerose@att.net"