Reset all tables sequence values in postgres with knex

reset-knex-seq.js

return await knex.transaction(async t => {
   try {
      // Retrieve table names (excluding migrations_lock)
      const tables = (await knex
        .raw(`
          SELECT table_name FROM information_schema.tables
          WHERE table_schema = 'public'
        `)
        .transacting(t)
      )
      .rows
      .map(r => r.table_name)
      .filter(tableName => tableName !== 'migrations_lock');

      // reset serial sequence values
      await Promise.all(tables.map(async tableName => await knex
        .raw(`
          SELECT
            setval(pg_get_serial_sequence('${tableName}', 'id'),
            coalesce(max(id), 0) + 1, false)
          FROM ${tableName};
        `)
        .transacting(t)
      ));

      return Promise.resolve(await t.commit());
    } catch (error) {
      Promise.reject(await t.rollback(error));
    }
})