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
Post a Comment