title: ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query
body: <p>Hi I am trying to insert into a table tester3 it fails when i use the syntax</p>
  <pre><code>insert into tester3 (UN0, UN1) values ( 1, 'jishnu1');
  </code></pre>
  <p>but</p>
  <pre><code>insert into tester3 values ( 1, 'jishnu1');
  </code></pre>
  <p>is working fine.</p>
  <pre><code>mydb=# CREATE TABLE tester3
  mydb-#    (
  mydb(#     &quot;UN0&quot; integer,
  mydb(#     &quot;UN1&quot; VARCHAR(40)
  mydb(#    );
  CREATE TABLE
  mydb=# insert into tester3 (UN0, UN1) values ( 1, 'jishnu1');
  ERROR:  column &quot;un0&quot; of relation &quot;tester3&quot; does not exist
  mydb=# \d tester3
             Table &quot;public.tester3&quot;
   Column |         Type          | Modifiers
  --------+-----------------------+-----------
   UN0    | integer               |
   UN1    | character varying(40) |
  </code></pre>
  <p>I think i am missing something very trivial, I tried someother column names some of them works fine and some are not working. I am confused. Does PostgreSQL have restriction in column names for which works the 1st syntax of insert query works?</p>
  <hr />
  <p><strong>Edit :</strong></p>
  <p>Checkout Girdon Linoff <a href="https://stackoverflow.com/a/31072263/3651739">answer</a> , as <a href="https://stackoverflow.com/users/271959/frank-heikens">Frank Heikens</a> pointed out the other column names which were working without quotes were in <strong>lower case</strong>.</p>
  <blockquote>
  <p>Lower case column is the standard within PostgreSQL and also works without quotes</p>
  </blockquote>