INSERT INTO sys_admin.published_services (
    schema, name, style
) VALUES
    ('waterway', 'fairway_marks_bcnlat_ienc', (
        SELECT style FROM sys_admin.published_services
        WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')),
    ('waterway', 'fairway_marks_boylat_ienc', (
        SELECT style FROM sys_admin.published_services
        WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')),
    ('waterway', 'fairway_marks_daymar_ienc', (
        SELECT style FROM sys_admin.published_services
        WHERE schema = 'waterway' AND name = 'fairway_marks_daymar'));

INSERT INTO sys_admin.grouped_layers VALUES
  ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0),
  ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2),
  ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5);

WITH upd AS (
    UPDATE sys_admin.grouped_layers
        SET name = name || '_hydro'
        WHERE schema = 'waterway' AND name IN(
            'fairway_marks_bcnlat',
            'fairway_marks_boylat',
            'fairway_marks_daymar'))
UPDATE sys_admin.published_services
    SET name = name || '_hydro'
    WHERE schema = 'waterway' AND name IN(
        'fairway_marks_bcnlat',
        'fairway_marks_boylat',
        'fairway_marks_daymar');