I am trying to merge data from a U.S. states shapefile with data on each state. I used this SQL query which is supposed to work:
SELECT * FROM child_poverty_by_state UPDATE child_poverty_by_state SET the_geom = us_states.the_geom FROM us_states WHERE us_states.state = child_poverty_by_state.state
The table "us_states" which is the shapefile, doesn't auto-populate in the query. Not sure why, is there an error with my query?