From: | will trillich <will(at)serensoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Can you use array data types w/ the COPY command? |
Date: | 2003-01-31 23:26:56 |
Message-ID: | 20030131232656.GC1464@mail.serensoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)serensoft(dot)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/ !
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-01-31 23:41:11 | Re: SQL-question (JOIN) |
Previous Message | Garo Hussenjian | 2003-01-31 23:25:49 | Re: Query gone wild |