Can you use array data types w/ the COPY command?
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
On Wed, Jan 29, 2003 at 03:31:06PM -0500, Peter E. Chen wrote:
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?
here's how i'd find out--
create temp table test(
i int[],
v varchar
);
insert into test values('{0}','zero');
insert into test values('{1,20,300,4000}','trend');
insert into test values('{2020}','vision');
insert into test values('{1,2,4,8,16,32,64,128}','binary');
copy test to stdout;
and see what format it uses. that's probably what it'll want on
the read-it-back-in side.
--
There are 10 kinds of people:
ones that get binary, and ones that don't.
will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !