ST_Reverse — Return the geometry with vertex order reversed.
geometry ST_Reverse(geometry  g1);
Can be used on any geometry and reverses the order of the vertices.
Enhanced: 2.4.0 support for curves was introduced.
            
 Questa funzione supporta il 3d e non distrugge gli z-index. 
            
 Questa funzione supporta le Polyhedral Surface. 
SELECT ST_AsText(geom) as line, ST_AsText(ST_Reverse(geom)) As reverseline
FROM
(SELECT ST_MakeLine(ST_Point(1,2),
                ST_Point(1,10)) As geom) as foo;
--result
                line         |     reverseline
---------------------+----------------------
LINESTRING(1 2,1 10) | LINESTRING(1 10,1 2)