Eu poderia fazer algo do tipo...

INSERT INTO targettable (col1, col2, col3)
> SELECT col1, col2 || '_' || nextval('sequence_name')::text, col3
> FROM stagingtable;


?
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a