I have a geometry column stored as text e.g.:
in PostgreSQL db with PostGIS. This for a point geometry with the EPSG:2193.
How do I convert this text column to a geometry column?
I have seen this question which is essentially the same, but the answer does not work.