ogr2ogr -f "PostgreSQL" PG:"host=<your_host> port=<your_port> user=<user_with_create_rights> password=<your_password> dbname=<your_db_name>" "<path>/<to>/<shapefile>/<file_name>.shp" -nlt LINESTRINGZM -nln <new_table_name> -sql "SELECT road_code, MakeLine(MakePointZM(ST_X(GEOMETRY), ST_Y(GEOMETRY), elevation, distance)) AS geom FROM <file_name> GROUP BY road_code ORDER BY distance" -dialect sqlite