I have a linestring geometry in my Postgres database. I wanted to extract the latitude-longitude coordinates of each point inside the linestring. Example
"0102000020E610000002000000CCDA5CEB41D323406E2A9CEE86C54A40CCDA5CEB41D323406E2A9CEE86C54A40"
"0102000020E610000002000000AF5FB01BB6CD22407C7E18213C8E4A40AF5FB01BB6CD22407C7E18213C8E4A40"
Till now, I have executed the query
SELECT st_astext(geometry) from warning_vmz;
result
"LINESTRING(7.17999 52.66463,7.17899 52.66563,7.17857 52.66604)"
"LINESTRING(7.2860666 53.1664885,7.2860666 53.1664885)"
so I have tried the another function
Select ST_DumpPoints(ST_GeomFromText(st_astext(geometry))) from warning_vmz;
output
"({1},01010000004C89247A19652240E8A4F78DAF8D4A40)"
"({2},010100000012BD8C62B965224076543541D48D4A40)"
If I use ST_DumpPoints(ST_GeomFromText(geometry)) then I get an error
ERROR: parse error - invalid geometry
HINT: "0102000020E6100000711300004C" <-- parse error at position 28 within geometry
********** Error **********