title: Why does Postgresql say "schema does not exist"
body: <p>How can i get this query to work?</p>
  
  <pre><code>SELECT weather.id, cities.name, weather.date, weather.degree
  FROM weather JOIN weather.city_id ON cities.id
  WHERE weather.date = '2011-04-30';
  </code></pre>
  
  <p>ERROR: schema "weather" does not exist.</p>
  
  <p>weather is not schema, it's a table!</p>