title: Fixing column "columnname" does not exist pgsql in database. Double quote vs single quote error
body: <p>I have a table review(movie_id, user_id, reviewtext, date, time, likes, status)/
  I get the error</p>
  
  <pre><code>column "exist" does not exist LINE 1: INSERT INTO review values ($1, $2, $3,$4,$5 ,0,"exist") ^ )
  </code></pre>
  
  <p>when I want to insert values into a postgresql database. I can not modify the code anymore so is there any way to make this work by altering the database like adding a column?</p>
  
  <p>The code to insert is as follows:</p>
  
  <pre><code> $query = $this-&gt;db-&gt;prepare('INSERT INTO review values (:movieid, :userid, :review,:date,:time ,0,"exist")');
   $result = $query-&gt;execute(Array(':movieid' =&gt; $movieid, ':userid' =&gt; $userid, ':review' =&gt; $review, ':date' =&gt; $date, ':time' =&gt; $time));
  </code></pre>
  
  <p>I understand that a way to fix this is to use single quotes for the column 'status' but the only thing I can do is alter the database.</p>