I have a PostGIS table with three columns
(rid, rast, fileName), now I want to add a geometry column and populate the geometry column using the rast column. A single rast index may have multiple geometries.
Normally to get geometry I use:-
SELECT geom FROM elevationData,LATERAL ST_PixelAsPoints(rast, 1)
How can I add and populate the geometry column? I am getting confused on how to use the WHERE clause in this scenario.