export distance summaries with points from postgres (+postgis) db to csv file. Includes coordinates of customers and stops, as well as spherical distance

export_to_csv.sql

\copy (select cd.name, pv.id as variation_id,
    st_distance_sphere(cd.location, pv.location) as distance,
    cd.city,
    cd.address,
    li.name as product,
    pv.stop as bus_stop,
    ST_X(pv.location) as stopX,
    ST_Y(pv.location) as stopY,
    ST_X(cd.location) as customerX,
    ST_Y(cd.location) as customerY
from triply_order o, triply_order_line_items oli, simple_line_item li, product_variant pv, customer_details cd
where oli.line_items_id = li.id
    and li.variation_id = pv.id
    and oli.triply_order_id = o.id
    and o.customer_details_id = cd.id
    and cd.location is not null) to '/Users/dev/Documents/file.csv' with csv