Re: Unique UUID value - PostgreSQL 9.2

On Mon, Mar 14, 2016 at 4:05 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Mon, Mar 14, 2016 at 3:51 PM, drum(dot)lucas(at)gmail(dot)com <
> drum(dot)lucas(at)gmail(dot)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.
​