postgresql - Returning clause in insert statement in Mulesoft connector -


we using mulesoft sending bunch of records 1 system another. target on postgres db. know there query like

insert t1 (c2,c3) values (v2, v3) returning to_char(c1,'99') var_id; 

in postgres returns generated id newly created record. there way same thing in mulesoft connector know column data generated.

i don't know if work, maybe use insert query select operation in database connector.


Comments