ogr2ogr -f GeoJSON endpoints.json  "PG:host=localhost dbname=dbname user=user password=password"  -sql "SELECT ST_AsText(ST_EndPoint(path::geometry)) from routes"

COPY (
        SELECT starttime, endtime, lat, lon from routes
    ) TO 'endpoints.csv' WITH CSV HEADER DELIMITER ',';