Thread

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

   Peter E. Chen <pchen3@jhmi.edu> — 2003-01-29T20:31:06Z

   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
   
   
   

2. Re: Can you use array data types w/ the COPY command?

   Will Trillich <will@serensoft.com> — 2003-01-31T23:26:56Z

   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/ !