title: Postgres - spaces and special characters in column name - how to select these in query
body: <p>I have table in postgres test1 and columns <strong>"Username","# of Applications", "# of R Applications" .</strong></p>
  
  <p>when tried to query these using select query i get error-</p>
  
  <pre><code>select Username, "# of Applications","# of R Applications" from public.test1 
  </code></pre>
  
  <p>Error
      ERROR:  column "username" does not exist
      LINE 1: select Username, "# of Applications" from public.test1...</p>
  
  <p>Similarly for all other 2 columns as well....</p>
  
  <p>how do i select these columns in select query?</p>