I have some MultiPolygon geometries in SRID 4258 and am trying to transform them into SRID 4326. When I run the following command, however, the output still seems to be in SRID 4258.
SELECT ST_AsText(ST_Transform(ST_Centroid(geom), 4326)) FROM geoms_to_convert LIMIT 1
I am converting to a point to see if the transform works, and the end goal is to have the point return in lat and long.
I don't see what I am doing wrong and am relatively new to PostGIS. I have confirmed that both projections are present in the
spatial_ref_sys table and am using PostGIS version 2.4.