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

From: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Can you use array data types w/ the COPY command?
Date: 2003-01-29 20:31:06
Message-ID: JBEOIGCPFENBBBIKPPLCKEECCOAA.pchen3@jhmi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terri Lerose 2003-01-29 20:37:46 [General] unsubscribe "Terri.Lerose@att.net"
Previous Message Dave Page 2003-01-29 20:20:02 Re: Error when accessing tables with deleted columns