I have point data, which store the "pharmacy_name" field

I also have street data (as linestring), which store the "street_name" field.

I want to know which pharmacy is located on which street. How can I calculate this with a SQL query in PostGIS?

Browse other questions tagged or ask your own question.