Skip to content

PostgreSQL:Update

선택적 업데이트

UPDATE table_name SET field_name=CASE WHEN field_name='exp1' THEN 'result1'
                                                             WHEN field_name='exp2' THEN 'result2'
                                                             ELSE 'other'
                                                             END;

UPSERT

PostgreSQL:InsertInto#UPSERT 항목 참조.

See also