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

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