Превышает длину 8000 символов

CREATE VIEW test.my_view1 AS 
SELECT
    n.nspname::text AS schema_name
    ,CASE p.prokind
        WHEN 'f' THEN 'FUNCTION'
        WHEN 'p' THEN 'PROCEDURE'
        WHEN 'a' THEN 'AGGREGATION'
        WHEN 'w' THEN 'WINDOW'
    END AS kind,
    p.oid::INTEGER,
    p.proname::text AS pro_name,
    pg_get_functiondef(p.oid) AS definition
FROM
    pg_proc p
LEFT JOIN
    pg_namespace n
ON
    p.pronamespace = n.oid
LEFT JOIN 
    pg_language l
ON
    p.prolang = l.oid
LEFT JOIN 
    pg_type t
ON
    t.oid = p.prorettype
WHERE 
    l.lanname IN ('sql', 'plpgsql')
    AND
    n.nspname = 'test'
ORDER BY 
    n.nspname,
    p.proname,
    p.oid
;

CREATE VIEW test.my_view1 AS 
WITH
-- Получаем исходные данные
source_data AS (
    SELECT
        n.nspname::text AS schema_name,
        p.oid::INTEGER,
        CASE p.prokind
            WHEN 'f' THEN 'FUNCTION'
            WHEN 'p' THEN 'PROCEDURE'
            WHEN 'a' THEN 'AGGREGATION'
            WHEN 'w' THEN 'WINDOW'
        END AS kind,
        p.proname::text AS pro_name,
        pg_get_functiondef(p.oid) AS definition
    FROM
        pg_proc p
    LEFT JOIN
        pg_namespace n ON p.pronamespace = n.oid
    LEFT JOIN 
        pg_language l ON p.prolang = l.oid
    WHERE 
        l.lanname IN ('sql', 'plpgsql')
        AND
        n.nspname = 'test'
),
-- Вычисляем длину и сколько нужно частей для каждой строки
part_calculation AS (
    SELECT
        schema_name,
        kind,
        oid,
        pro_name,
        definition,
        len,
        (len + length_part-1) / length_part AS part_count,
        length_part
    FROM
        (SELECT
            schema_name,
            kind,
            oid,
            pro_name,
            definition,
            LENGTH(definition) AS len,
            8000 AS length_part
        FROM
            source_data) t
),
-- Генерируем номера частей для каждой строки
parts_generation AS (
    SELECT
        pc.schema_name,
        pc.kind,
        pc.oid,
        pc.pro_name,
        pc.definition,
        pc.len AS total_length,
        pc.part_count,
        pc.length_part,
        gs.n AS part_number
    FROM
        part_calculation pc
    CROSS JOIN lateral
        generate_series(1, greatest(pc.part_count, 1)) AS gs(n)
)
-- Извлекаем соответствующие подстроки
SELECT
    t.schema_name,
    t.kind,
    t.oid,
    t.pro_name,
    t.length_part,
    t.part_number,
    t.definition_chunk,
    LENGTH(t.definition_chunk) AS chunk_length,
    t.total_length,
    t.total_parts
FROM
    (SELECT
        pg.schema_name,
        pg.kind,
        pg.oid,
        pg.pro_name,
        pg.length_part,
        pg.part_number,
        SUBSTRING(
            pg.definition,
            (pg.part_number - 1) * length_part + 1,
            length_part
        ) AS definition_chunk,
        pg.total_length,
        pg.part_count AS total_parts
    FROM
        parts_generation pg
    ) t
ORDER BY 
    t.schema_name,
    t.pro_name,
    t.oid,
    t.part_number
;

SELECT 
    schema_name,
    kind,
    oid,
    pro_name,
    STRING_AGG(CAST(definition_chunk AS NVARCHAR(MAX)), '') WITHIN GROUP (ORDER BY part_number) AS definition
FROM
    [Test_link].test_DB.test.my_view1
GROUP BY
    schema_name,
    kind,
    oid,
    pro_name;