Re: Unique UUID value - PostgreSQL 9.2 - Mailing list pgsql-general

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