daytab表向historytab表合并数据

MERGE INTO public.historytab TRG

USING  public.daytab SRC ON (TRG.ID =SRC.ID )

WHEN MATCHED THEN UPDATE SET NAME=SRC.NAME,PW =SRC.PW

​​WHEN NOT MATCHED THEN INSERT(ID,NAME,PW) VALUES (SRC.ID,SRC.NAME,SRC.PW)​​