title: insert query in database table get me problem
body: <pre><code>for jp_number in datadict:
  ct_id = &quot;&quot;.join(datadict[jp_number]).replace(&quot;'&quot;, '')
    
  insert_query = &quot;&quot;&quot;INSERT INTO dwb_weekly_snapshot(jp_number, ct_id) VALUES(%s, %s)&quot;&quot;&quot;
  cursor.execute(insert_query, (jp_number,ct_id))
  </code></pre>
  <p>I am getting 'M': 'operator does not exist: character varying = numeric' as Error</p>
  <p>jp_number is varchar(20) and ct_id (text) in table I tried exaclty above query</p>
  <p>Same Erro coming for</p>
  <pre><code>update_query = &quot;&quot;&quot;update dwb_weekly_snapshot set ct_id= %s where jp_number = %s &quot;&quot;&quot;
   cursor.execute(update_query, (ct_id, imnumber))
  </code></pre>