title: psycopg2.ProgrammingError: column of relation does not exist
body: <p>Trying to insert data into PostgreSQL database.</p>
  
  <p>Python code:</p>
  
  <pre><code>myFields = ((DOT_Number,),(Entity_Type,),(Operating_Status,),(Legal_Name,),
  (Phone,),(Address,)
  )
  
  query = """ INSERT INTO saferdb_question( DOT_Number, Entity_Type, Operating_Status, Legal_Name, Phone, Address)VALUES ( %s, %s, %s, %s, %s, %s);"""
  
  cur.execute( query, myFields)
  </code></pre>
  
  <p>Getting error:</p>
  
  <pre><code>Traceback (most recent call last):
    File "scraper.py", line 189, in &lt;module&gt;
      cur.execute( query, myFields)
    File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/psycopg2/extras.py", line 144, in execute
      return super(DictCursor, self).execute(query, vars)
  psycopg2.ProgrammingError: column "dot_number" of relation "saferdb_question" does not exist
  LINE 1:  INSERT INTO saferdb_question( DOT_Number, Entity_Type, Oper...
  </code></pre>
  
  <p>SQL from PostgreSQL that created the table:</p>
  
  <pre><code>CREATE TABLE public.saferdb_question
  (
      id integer NOT NULL DEFAULT nextval('saferdb_question_id_seq'::regclass),
      "DOT_Number" character varying(10) COLLATE pg_catalog."default" NOT NULL,
  </code></pre>
  
  <p>...</p>
  
  <pre><code>    "Phone" character varying(15) COLLATE pg_catalog."default" NOT NULL,
      "Address" character varying(200) COLLATE pg_catalog."default" NOT NULL,
  
  )
  WITH (
      OIDS = FALSE
  )
  TABLESPACE pg_default;
  
  ALTER TABLE public.saferdb_question
      OWNER to postgres;
  </code></pre>