title: Select columns with particular column names in PostgreSQL
body: <p>I want to write a simple query to select a number of columns in PostgreSQL. However, I keep getting errors - I tried a few options but they did not work for me. At the moment I am getting the following error:</p>
  
  <blockquote>
    <p>org.postgresql.util.PSQLException: ERROR: syntax error at or near
    "column"</p>
  </blockquote>
  
  <p>To get the columns with values I try the followig:</p>
  
  <pre><code>select * from weather_data where column like '%2010%'
  </code></pre>
  
  <p>Any ideas?</p>