I have zero experience with PostGIS and SQL, but I'm trying to create points along the line at specific distance. I am trying this method: Getting points along line at defined distance using PostGIS? but I cannot create an actual point table with geometry using my line table. I was trying something like this:
CREATE TABLE point_table AS SELECT gid, ST_AsText((dp).geom) As wkt_geom FROM ( SELECT ST_DumpPoints( ST_Segmentize( ST_GeomFromText('LINESTRING(1 30, 15 30)',5514), 1 ) ) AS dp ) AS geom from my_line;
But I am not successful at all. Can some of you explain to me how to do this basic task since I am a complete noob?