Example from https://postgis.net/docs/ST_DumpPoints.html to Explode Linestring into Points

explode_linestring_points.sql

select edge_id, 
       (dp).path[1] As index, 
       ST_AsText((dp).geom) As wktnode
from (select 1 As edge_id,
      ST_DumpPoints(ST_GeomFromText('LINESTRING(1 2, 3 4, 10 10)')) as dp
union all
select 2 As edge_id,
       ST_DumpPoints(ST_GeomFromText('LINESTRING(3 5, 5 6, 9 10)')) as dp
   ) as foo;