WITH columns AS (SELECT table_schema, table_name, column_name
FROM INFORMATION_SCHEMA.columns
WHERE  (table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') AND 
table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)),
proc AS (SELECT 
  pg_namespace.nspname AS routine_schema, 
  pg_proc.proname AS routine_name, 
  pg_get_function_identity_arguments(pg_proc.oid) AS parameters,
  CASE WHEN pg_proc.prokind='f' THEN 'FUNCTION'
  WHEN pg_proc.prokind='p' THEN 'PROCEDURE'  
  WHEN pg_proc.prokind='w' THEN 'WINDOW FUNCTION' END AS routine_type,
  CASE WHEN pg_proc.prosqlbody IS NULL THEN pg_proc.prosrc ELSE pg_get_function_sqlbody(pg_proc.oid) END  AS routine_src,
  unnest(pg_proc.proargnames) AS routine_param
FROM 
  pg_catalog.pg_proc, 
  pg_catalog.pg_namespace
WHERE pg_proc.pronamespace = pg_namespace.oid 
AND pg_proc.prokind<>'a'
AND pg_proc.proname NOT IN ('f_assume_you_must_use_files', 'f_check_format_comma_separated_list', 'f_check_password', 'f_default_value_with_no_match') 
AND pg_proc.proargnames IS NOT NULL 
AND pg_proc.proretset=FALSE 
AND pg_namespace.nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
AND (CASE WHEN pg_proc.prosqlbody IS NULL THEN pg_proc.prosrc ELSE pg_get_function_sqlbody(pg_proc.oid) END)~*'((SELECT[^;]+FROM)|((INSERT|UPDATE|DELETE)[[:space:]]))')
SELECT routine_schema, routine_name,  parameters, routine_type, routine_param AS suspected_parameter_name, 
regexp_replace(replace(routine_src, routine_param , '<b>' || routine_param || '</b>'),'[\r\n]','<br>','g') AS routine_src,  column_name, table_schema, table_name
FROM columns, proc
WHERE columns.column_name=proc.routine_param 
AND proc.routine_src ILIKE '%' || columns.table_name || '%' 
ORDER BY routine_schema, routine_name, parameters, routine_param;