title: Convert SQLITE SQL dump file to POSTGRESQL
body: <p>I've been doing development using SQLITE database with production in POSTGRESQL.  I just updated my local database with a huge amount of data and need to transfer a specific table to the production database.</p>
  
  <p>Based on running <code>sqlite database .dump &gt; /the/path/to/sqlite-dumpfile.sql</code>, SQLITE outputs a table dump in the following format:</p>
  
  <pre><code>BEGIN TRANSACTION;
  CREATE TABLE "courses_school" ("id" integer PRIMARY KEY, "department_count" integer NOT NULL DEFAULT 0, "the_id" integer UNIQUE, "school_name" varchar(150), "slug" varchar(50));
  INSERT INTO "courses_school" VALUES(1,168,213,'TEST Name A',NULL);
  INSERT INTO "courses_school" VALUES(2,0,656,'TEST Name B',NULL);
  ....
  COMMIT;
  </code></pre>
  
  <p>How do I convert the above into a POSTGRESQL compatible dump file that I can import into my production server?</p>