title: Why does postgreSQL detect this line as a column name?
body: <p>I'm doing this (Postgre)SQL excercize for a course i'm following; the objective is fairly simple i suppose:</p>
  <blockquote>
  <p>Insert data into courses using the data provided. Make sure id is system generated.</p>
  </blockquote>
  <p>for reference, this is the query to create said table</p>
  <pre><code>%%sql
  CREATE TABLE courses (
  course_id SERIAL PRIMARY KEY,
  course_name VARCHAR(60) NOT NULL,
  course_author VARCHAR(40) NOT NULL,
  course_status course_status,
  course_published_dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  );
  </code></pre>
  <p>and this is the query that i'm trying to run</p>
  <pre><code>%%sql
  INSERT INTO courses (course_id, course_name, course_author, course_status, 
  course_published_dt)
  VALUES 
  (&quot;Programming using Python&quot;, &quot;Bob Dillon&quot;, &quot;published&quot;, &quot;2020-09-30&quot;),
  (&quot;Data Engineering using Python&quot;, &quot;Bob Dillon&quot;, &quot;published&quot;, &quot;2020-07-15&quot;),
  (&quot;Data Engineering using Scala&quot;, &quot;Elvis Presley&quot;, &quot;draft&quot;),
  (&quot;Programming using Scala&quot;, &quot;Elvis Presley&quot;, &quot;published&quot;, &quot;2020-05-12&quot;),
  (&quot;Programming using Java&quot;, &quot;Mike Jack&quot;, &quot;inactive&quot;, &quot;2020-08-10&quot;),
  (&quot;Web Applications - Python Flas&quot;, &quot;Bob Dillon&quot;, &quot;inactive&quot;, &quot;2020-07-20&quot;),
  (&quot;Web Applications - Java Spring&quot;, &quot;Mike Jack&quot;, &quot;draft&quot;),
  (&quot;Pipeline Orchestration - Python&quot;, &quot;Bob Dillon&quot;, &quot;draft&quot;),
  (&quot;Streaming Pipelines - Python&quot;, &quot;Bob Dillon&quot;, &quot;published&quot;, &quot;2020-10-05&quot;),
  (&quot;Web Applications - Scala Play&quot;, &quot;Elvis Presley&quot;, &quot;inactive&quot;, &quot;2020-09-30&quot;),
  (&quot;Web Applications - Python Django&quot;, &quot;Bob Dillon&quot;, &quot;published&quot;, &quot;2020-06-23&quot;),
  (&quot;Server Automation - Ansible&quot;, &quot;Uncle Sam&quot;, &quot;published&quot;, &quot;2020-07-05&quot;);
  </code></pre>
  <p>when i run it, the message below appears:</p>
  <blockquote>
  <p>(psycopg2.errors.UndefinedColumn) column &quot;Programming using Python&quot; does not exist
  LINE 3:     (&quot;Programming using Python&quot;, &quot;Bob Dillon&quot;, &quot;published&quot;, ...</p>
  </blockquote>
  <p>i really don't get why it takes the first value of that row as the column name... what am i doing wrong? The very same slides i'm following picture queries done the same way!</p>