Check out example codes for "postgres list all stored procedures query". It will help you in understanding the concepts better.

Code Example 1

select n.nspname as schema,
       p.proname as procedure
from pg_proc p
join pg_namespace n on p.pronamespace = n.oid
where n.nspname not in ('pg_catalog', 'information_schema')
	and p.prokind = 'p'

Learn ReactJs, React Native from akashmittal.com