DO LANGUAGE plpgsql
$$
DECLARE table_suffix varchar;
BEGIN
    FOREACH table_suffix IN ARRAY ARRAY[
        'bcnlat_hydro', 'bcnlat_ienc', 'boycar',
        'boylat_hydro', 'boylat_ienc', 'boysaw',
        'boyspp', 'daymar_hydro', 'daymar_ienc',
        'lights', 'rtpbcn', 'topmar', 'notmrk']
    LOOP
        EXECUTE format(
            'CREATE INDEX fairway_marks_%1$s_validity '
            'ON waterway.fairway_marks_%1$s USING GiST (validity)',
            table_suffix);
    END LOOP;
END;
$$;