I have a table of roads and a table of points. I'd like for each point to have the ID of the closest road, as well as the distance to that road.
The line data has both the path type and the geometry type for its coordinates. The points have XY coordinates. What would be the best way to go about finding the closest road using PostGIS?