Importing the Master Plan

When importing data into Postgres from a CSV, it's imperative that you do not try to alter the data - do that by explicitly transforming the data later on.

That means we need to import everything as text, because that's the core string type in Postgres (as opposed to text etc).

To create our schema and table:

<span class="hljs-keyword">create</span> schema csvs;
<span class="hljs-keyword">create table</span> csvs.master_plan(
  start_time_utc text,
  duration text,
  <span class="hljs-type">date</span> text,
  team text,
  spass_type text,
  target text,
  request_name text,
  library_definition text,
  title text,
  description text
);

Copying data from a CSV into our new table:

<span class="hljs-keyword">copy</span> csvs.master_plan 
<span class="hljs-keyword">from</span> <span class="hljs-string">&#x27;[Absolute path to]/csvs/master_plan.csv&#x27;</span>
delimiter <span class="hljs-string">&#x27;,&#x27;</span> header csv;