I am new to database sorry if this is basic.
I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column?
This is my script used to select the POINT geometry
SELECT count(*) from public.test1 where GeometryType(geometry) = 'POINT'
so my update set might be something like
UPDATE test1 SET GeometryType(geometry) = 'POINT' = newcolumn;