UPSERT

DOCS • LANG

---

The UPSERT statement.

See APIS ➞ client.query(), table.upsert()

Basic Upsert

// (a): SQL syntax
const result = await client.query(
    `UPSERT INTO public.users
        (name, email)
    VALUES ('Jane', 'jane@example.com')`
);

// (b): Object-based syntax
const result = await client.database('public').table('users').upsert(
    { name: 'Jane', email: 'jane@example.com' }
);

Multi-Dimensional Upserts

See also ➞ Magic Paths