title: PostgreSQL ERROR column does not exist refers to a column value
body: <p>I have a table <code>projects</code> in postgreSQL that looks like below</p>
  <pre><code>id.    project_name.   col3.  col4
  1111.   test.          ...    ...
  </code></pre>
  <p>I want to insert a new row for a new <code>id</code> only if the <code>id</code> does not already exist. So I wrote below query</p>
  <pre><code>INSERT INTO projects(id, project_name)
  VALUES(&quot;1234&quot;, &quot;Test_Project&quot;)
  ON CONFLICT (id)
  DO NOTHING
  </code></pre>
  <p>But it throws me an error</p>
  <pre><code>Query 1 ERROR: ERROR:  column &quot;1234&quot; does not exist
  LINE 2: VALUES(&quot;1234&quot;, &quot;Test_Project_...
  </code></pre>
  <p>Please suggest.</p>
  <p>** EDIT**</p>
  <p>The <code>id</code> column in the table is a uuid and not unique. There can be multiple rows with the same id. Based on GMBs suggestion, I tried below</p>
  <pre><code>INSERT INTO projects(id, project_name)
      VALUES('1234', 'Test_Project')
      ON CONFLICT (create unique index on projects(id))
      DO NOTHING
  </code></pre>
  <p>I get below error with it</p>
  <pre><code>Query 1 ERROR: ERROR:  syntax error at or near &quot;create&quot;
  LINE 3: ON CONFLICT (create unique index on projects(id...
  </code></pre>
  <p>I am new to this so I am sure missing something obvious.</p>