So i need to set a 30 meter Buffer around a road in a Layer and visualize it in QGIS. The road is split in 8 segments( don´t think it makes a difference).
Tried this code:
select a.ref, a.geom, st_buffer(a.geom, 30) from au.roads a where a.ref='A306'
When i load it in QGIS it doesn´t show a Buffer around that road. What am i doing wrong?