update a set city=b.name from b where st_contains(b.the_geom, a.the_geom)

Update a set CITY = b.NAME from b where (b.the_geom.STContains(a.the_geom) = 1)