PostgreSQL upsert

SQLUpdated Oct 22, 2026

SQL

INSERT INTO users (email, display_name, updated_at)
VALUES ($1, $2, now())
ON CONFLICT (email) DO UPDATE
SET display_name = EXCLUDED.display_name,
    updated_at = EXCLUDED.updated_at
RETURNING id, email, display_name;