I have a river network (Line with arrow as shown in image below) and I need to create perpendicular lines to the river at every 15 meters as you walk along it (see image below). Is there a function in Postgis capable of doing this?

Thanks

[![enter image description here][1]][1]


  [1]: https://i.sstatic.net/UOCTm.png