How to insert with Knex — Basic

SQL / Knex Knex queries

Insert one or more records using knex('table').insert() and optional returning().

Learn: insert() accepts an object or array for bulk inserts. Use returning('*') on PostgreSQL to get the inserted row back for your 201 response.

Supplementary examples

Insert with returning

function create(data) {
  return knex("pastes")
    .insert(data)
    .returning("*")
    .then((rows) => rows[0]);
}

Course example

const knex = require("../db/connection");
function create(supplier) {
return knex("suppliers")
.insert(supplier)
.returning("*")
.then((createdRecords) => createdRecords[0]);
}
module.exports = {
create,
};

Additional references & examples

Knex.js documentation
Query builder, migrations, seeds, and connection configuration.
PostgreSQL documentation
SQL syntax, data types, and database administration reference.