I executed a query to know where a MultiLineString touches itself using st_touches from postgis as shown here :
select a.id,b.id ,a.geom,b.geom, ST_Touches(a.geom, b.geom) from pipe AS a , pipe AS b where b.id > a.id and ST_Touches(a.geom, b.geom) = true
yet the result is boolean (true or false).
I want to generate a point layer in each touching location. I tried to do create as select but it returned a table without geometry column.
How can I generate the point locations?