PostgreSQL view that lists all functions and their source code

postgres-view-functions.sql

create or replace view showfunctions as
select
l.lanname,
t.typname || ' = ' || n.nspname || '.' || 
  p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'
as function_definition,
(select case when lanname <> 'c' 
 then '\n\n'||prosrc ||'\n\n'
 else '\n'||prosrc ||'.so\n\n'
end) as source
from pg_proc p, pg_type t, pg_namespace n, pg_language l
where p.prorettype = t.oid and p.pronamespace = n.oid
   and p.prolang = l.oid;

select
l.lanname,
t.typname || ' = ' || n.nspname || '.' ||
p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'
as function_definition,
(select case when lanname <> 'c'
then '\n\n'||prosrc ||'\n\n'
else '\n'||prosrc ||'.so\n\n'
end) as source

select
l.lanname,
t.typname || ' = ' || n.nspname || '.' ||
p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'
as function_definition,
(select case when lanname <> 'c'
then '\n\n'||prosrc ||'\n\n'
else '\n'||prosrc ||'.so\n\n'
end) as source