title: Postgres and Laravel how to change column from type string to integer?
body: <p>I am trying to change a column from type string to integer on Postgres and Laravel 6.x. I've tried to do this with a migration like so:</p>
  <pre><code>    public function up()
      {
          Schema::table('job_listings', function (Blueprint $table) {
              $table-&gt;integer('company_id')-&gt;change();
          });
      }
  </code></pre>
  <p>When I run this migration I get an error that the column cannot be automatically cast to an integer:</p>
  <pre><code>In Connection.php line 664:
  
    SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column &quot;company_id&quot; cannot be cast automatically to type integer
    HINT:  You might need to specify &quot;USING company_id::integer&quot;. (SQL: ALTER TABLE job_listings ALTER company_id TYPE INT)
  
  
  In PDOStatement.php line 123:
  
    SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column &quot;company_id&quot; cannot be cast automatically to type integer
    HINT:  You might need to specify &quot;USING company_id::integer&quot;.
  
  
  In PDOStatement.php line 121:
  
    SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column &quot;company_id&quot; cannot be cast automatically to type integer
    HINT:  You might need to specify &quot;USING company_id::integer&quot;.
  </code></pre>
  <p>How do we specify USING to change this column from type string to integer in PostgreSQL?</p>