title: Find all polygons containing a point in PostGIS
body: <p>I've managed to get a list of all points contained in a specific polygon, but how can I query a PostGIS database to find out what polygons contain a given point?</p>
  
  <p>Suppose I have a table <code>places</code> with lat/lon locations (<code>POINT</code> types) and a <code>areas</code> table with a <code>geometry</code> column with <code>MULTIPOLYGON</code> types.</p>
  
  <p>How can I write a query that will return a list of places and all the areas that contain each point? For example: </p>
  
  <pre><code>place_id, area_ids
  1, {23,425,536}
  2, {30,425}
  -- etc...
  </code></pre>