update_postgres_with.sql

WITH line_journey_pattern AS (
    SELECT jp.id AS journey_pattern_id, l.name AS line_name
    FROM journey_patterns jp
             JOIN routes r ON jp.route_id = r.id
             JOIN lines l ON r.line_id = l.id
    WHERE l.name IS NOT NULL
      AND l.name <> ''
)
UPDATE journey_patterns jp
SET name = ljp.line_name || ' - ' || jp.name
FROM line_journey_pattern ljp
WHERE ljp.journey_pattern_id = jp.id;