How to findout direction PostGIS
You could use ST_Azimuth for that : http://postgis.net/docs/ST_Azimuth.html
This will give you an angle in radians and the 0 rad angle stands for a point in the north of your main point
You could use ST_Azimuth for that : http://postgis.net/docs/ST_Azimuth.html
This will give you an angle in radians and the 0 rad angle stands for a point in the north of your main point