WITH routines AS (SELECT 
  pg_namespace.nspname AS specific_schema, 
  pg_proc.proname AS routine_name,   
  pg_proc.proname || '_' || pg_proc.oid AS specific_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,
 regexp_replace(pg_get_functiondef(pg_proc.oid),'[\r\n]','<br>','g')  AS routine_src  
FROM 
  pg_catalog.pg_proc, 
  pg_catalog.pg_namespace
WHERE 
  pg_proc.pronamespace = pg_namespace.oid   
  AND pg_proc.prokind<>'a'  
  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 pg_get_functiondef(pg_proc.oid)~*'(localtimestamp|current_timestamp|now[(][)])'
AND NOT EXISTS (SELECT 1
FROM pg_catalog.pg_depend d 
WHERE EXISTS (SELECT 1 FROM pg_catalog.pg_extension e WHERE d.refobjid=e.oid) AND
d.objid=pg_proc.oid)),
temp_columns AS (SELECT A.table_schema, A.table_name , A.column_name, A.data_type,A.column_default, D.domain_default
FROM information_schema.columns A
INNER JOIN information_schema.tables T USING (table_schema, table_name)
INNER JOIN information_schema.schemata S ON A.table_schema=S.schema_name
LEFT JOIN information_schema.domains D USING (domain_schema, domain_name)
WHERE A.data_type~*'(timestamp|date)'
AND T.table_type='BASE TABLE'
AND (A.table_schema = 'public'
OR S.schema_owner<>'postgres')
AND coalesce(A.column_default, D.domain_default)~*'(localtimestamp|current_timestamp|now[(][)])')
SELECT specific_schema AS routine_schema, routines.routine_name, parameters, routine_type, routine_src, table_schema, table_name, column_name, column_default, domain_default
FROM routines INNER JOIN INFORMATION_SCHEMA.routine_column_usage USING (specific_schema, specific_name)
INNER JOIN temp_columns USING (table_schema, table_name, column_name)
WHERE routine_src NOT ILIKE '%' || coalesce(column_default, domain_default) || '%'
ORDER BY routine_schema, routines.routine_name, parameters;