I am new to postgresql. I have imported a 256kb sample raster (.tiff) into postgres with tilesize 100x100. Now I need to select the area (rectangle) from the center of the image using sql query. Then to populate it into another raster table which then need to be visualize using QGIS.
Below is the raster and the red box is the area I want to select in postgres.
I understand that it is the similar situation in this post here. But I do not really have any clue how to begin, as I do not have the coordinates or other information.
Can someone help me with the first step on selecting only the bounded area within the raster?