title: select column name from H2 with columns that have spaces
body: <p>I am attempting to query from a tab delimited file with H2 and java. When I <code>select *</code> there are no problems, however, one of the columns has a space in the column name. When I try to query on just that column I get an exception:</p>
  
  <pre><code>Caused by: org.h2.jdbc.JdbcSQLException: Column "EXAMPLE" not found; SQL statement:
  </code></pre>
  
  <p>It appears as though it is not grabbing both words in the column name (Example ColumnName), but only grabbing the first. </p>
  
  <p>This is what I have:</p>
  
  <pre><code>System.out.println( simpleJdbcTemplate.queryForList( "SELECT Example ColumnName FROM CSVREAD('" + fileName
                  + "', null,'UTF-8', chr(9)) where send = 1;", new Object[] {} ) );
  </code></pre>
  
  <p>I'm guessing there is a special syntax to do this, but I can't seem to find it. I've tried enclosing the column name in: square brackets, single quotes, double quotes, tick marks all to no avail.</p>
  
  <p>Is there a way to query H2 using columns that have spaces in the name?</p>