title: PostgreSQL - query syntax without quotes
body: <p>I have a little silly question. I have installed a PostgreSQL DB Server, but when I run query, there is a problem with column identifier without quotes. I don't know why the quotes around identifiers are needed. My query:</p>
  
  <pre><code>SELECT vc."CAR_ID"
    FROM "VEL_CAR" vc, "VEL_DRIVER" vd, "VEL_DRIVER_CAR" vdc
  WHERE vc."CAR_ID" = vdc."CAR_ID" and
        vdc."DRIVER_ID" = vd."DRIVER_ID";
  </code></pre>
  
  <p>My practice from Oracle DB is not to use ". So in Oracle:</p>
  
  <pre><code>SELECT vc.CAR_ID
    FROM VEL_CAR vc, VEL_DRIVER vd, VEL_DRIVER_CAR vdc
  WHERE vc.CAR_ID = vdc.CAR_ID and
        vdc.DRIVER_ID = vd.DRIVER_ID;
  </code></pre>
  
  <p>When I run this query without quotes in PostgreSQL it throws error about syntax:</p>
  
  <pre><code>ERROR:  column vc.car_id does not exist
  LINE 1: SELECT vc.CAR_ID
  </code></pre>
  
  <p>Do you know why?</p>
  
  <p><strong>--SOLVED--</strong>
  Thank you, now I solved the problem! It was about table creation. I created table objects using pgAdminIII and i wrote table name and column names uppercased. pgAdminIII created query with quotas - because of the names was uppercased. So query had to be written with quotas.</p>