INSERT

DOCS • LANG

---

The INSERT statement.

See also ➞ table.insert()

Basic Insert

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

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

Multi-Dimensional Inserts

See also ➞ Magic Paths