I am new to PostGIS and I can't find a way to intersect my raster map with my points shapefile.
The raster is the country and the shapefile is associated with the cities. I would like to determine the pixels positions of the cities in the raster map.
I read that ST_Intersects helps only with the intersection of two rasters.
Do you have any suggestions?