CREATE OR REPLACE PROCEDURE public.sp_add_numbers_redshift(
    IN a INTEGER,
    IN b INTEGER
)
AS $$
DECLARE
result INTEGER;
BEGIN
    result := a + b;
END;
$$ LANGUAGE plpgsql;

SELECT
    p.proname
FROM
    pg_catalog.pg_namespace n
JOIN pg_catalog.pg_proc p ON
    pronamespace = n.oid
WHERE
    n.nspname in ('public') AND p.proname LIKE 'sp%';