I have a table with a geometry column (polygon) in a projected coordinate system in meters. Let's say, I want to shift all the polygons by some constant. For example, every point in all polygons must be shifted by
X + 4 and
Y - 4. Is there a way to do that using PostGIS?
In QGIS, I can do that by selecting all the polygons and using the Move Feature tool. However, QGIS crashes as the amount of vector features is huge, so I try to complete it in PostgreSQL.