a placename point table in postgis with 'district' column.
a districts polygon shapefile with district name in 'Name' column. See the image below.
I would like to update the 'district' columns(in placename psql table) with the corresponding district name from the shapefile polygons in which each placename point feature reside.
How can I do this in QGIS? Or Is there any other way?