Name
ST_Reverse — Return the geometry with vertex order reversed.
Synopsis
geometry ST_Reverse(
geometry g1)
;
Description
Can be used on any geometry and reverses the order of the vertexes.
Examples
SELECT ST_AsText(the_geom) as line, ST_AsText(ST_Reverse(the_geom)) As reverseline
FROM
(SELECT ST_MakeLine(ST_MakePoint(1,2),
ST_MakePoint(1,10)) As the_geom) as foo;
--result
line | reverseline
---------------------+----------------------
LINESTRING(1 2,1 10) | LINESTRING(1 10,1 2)