SELECT ST_AsText(
     ST_MakeLine(                      --  <co id="co_code_st_value_3d_1" /> --
          ST_Translate(   --  <co id="co_code_st_value_3d_2" /> --
            ST_Force3D( (gd).geom ),  --  <co id="co_code_st_value_3d_3" /> --
               0,0,
               COALESCE(ST_Value(rast, (gd).geom), 0)  --  <co id="co_code_st_value_3d_4" /> --
          )
        )
) As line_3dwkt
FROM (SELECT
    ST_DumpPoints(   --  <co id="co_code_st_value_3d_5" /> --
     ST_GeomFromText('LINESTRING(444210 2438785,
          434125 2448785,  466666 2449780,
          47000 2459000)',
          26904 )
        ) As gd
   )
    As trail
     LEFT JOIN ch12.kauai
     ON ST_Intersects(rast, (gd).geom); --  <co id="co_code_st_value_3d_6" /> --