31 Aug
2009
31 Aug
'09
10:42 a.m.
On 28-08-2009 09:33:41 -0400, Matthew Jones wrote:
My solution is to create a sequence with the table, before batch loading my data I will get the next value of the sequence, then reset it to that value + the size of my batch and iterate over my batch adding that value.
Can't you COPY INTO a temporary table, and then INSERT INTO original_table (col2, col3, col4) SELECT col1, col2, col3 from temporary_table; ?