Break a LINESTRING or MULTILINESTRING into its constituent points with PostGIS.

gistfile1.sql

SELECT ST_AsText(
  ST_PointN(
    way,
    generate_series(1, ST_NPoints(way))
  )
)
FROM (
  SELECT (ST_Dump(way)).geom AS way
  FROM planet_osm_line WHERE osm_id=25813470) AS dumped;