title: alter auto increment using knexjs migration (postgres)
body: <p>I'm using knex.js and migrating one of the column to start from a different number (auto_increment).
  Is there a better way to alter the auto increment column using Postgres and Knex</p>
  
  <pre><code>const TABLE = 'my_table'
  const COL = 'id';
  
  exports.up = function (knex, Promise) {
    return Promise.all([
      knex.schema.withSchema('public').raw(`ALTER SEQUENCE ${TABLE}_${COL}_seq RESTART WITH 100000000000`)
    ]);
  };
  
  exports.down = function (knex, Promise) {};
  </code></pre>
  
  <p>I rather use knex function than <code>.raw</code></p>