On Mon, Mar 14, 2016 at 4:05 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Mar 14, 2016 at 3:51 PM, drum.lu...@gmail.com <
> drum.lu...@gmail.com> wrote:
>
>> I just need to know how can I do all of this
>>
>
> You may have missed my prior email.
>
> You cannot COPY directly into the target table. You must copy to a
> staging table. You then insert from the staging table to the target table,
> listing every single column, and replacing those columns you want to change
> with some kind of expression.
>
> Basically:
>
> INSERT INTO targettable (col1, col2, col3)
> SELECT col1, col2 || '_' || nextval('sequence_name')::text, col3
> FROM stagingtable;
>
>
In theory an INSERT trigger might work too - but this is likely to be
simpler and faster.
David J.
