中文
devexamples

Upsert With ON CONFLICT

Insert a row or update it when the unique key already exists, in one atomic statement that avoids a race between read and write.

SqlData Integrity

Code

snippet
INSERT INTO user_stats (user_id, login_count, last_login_at)
VALUES ($1, 1, now())
ON CONFLICT (user_id) DO UPDATE
SET
    login_count = user_stats.login_count + EXCLUDED.login_count,
    last_login_at = EXCLUDED.last_login_at
RETURNING user_id, login_count, last_login_at;

Related Examples