I am quite new to PostGIS.
I need take some points from an existing table and create a multipoint and save this.
How would i go about this?
The only way i can think without creating a new table is:
Alter table alter column geom TYPE geometry (MULTIPOINT,3857) USING ST_Multi(geom);
if i had to create a table what would the statement look like when using the x,y of the points in the point table?
Ive been asked to then find the centre of the mutlipoint, I know i need to use ST_Centroid but what would the code look like?