redshift sql functions code example

Example: how to see function in redshift

select * from pg_proc where proname ilike '%<function_name>%'