Re: Functions with COPY - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Functions with COPY
Date
Msg-id 20031127151934.GE24094@ns.snowman.net
Whole thread Raw
In response to Re: Functions with COPY  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
* Rod Taylor (pg@rbt.ca) wrote:
> How about COPY into a TEMP TABLE for 10k lines, then do an
> insert into real_table .... select .... from temp_table;
> which converts the data?
>
> You could of course thread the load so 2 or 3 processes execute the data
> import.

Sure, this would work, but it's a heck of alot more work from a
processing standpoint than either of the other options...
Stephen

pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Functions with COPY
Next
From: Stephen Frost
Date:
Subject: Re: Functions with COPY