Data/PostgreSQL
PostgreSQL merge 구문
바리새인
2024. 12. 21. 23:42
MERGE INTO target_table AS t
USING source_table AS s
ON t.id = s.id
WHEN MATCHED THEN
UPDATE SET column1 = s.column1
WHEN NOT MATCHED THEN
INSERT (column1, column2) VALUES (s.column1, s.column2);