sql - PostgreSQL: How to list all stored functions that access specific table -


for given table how can find functions uses fields table? have student table (studentid, studentname)

i want list of functions , triggers uses studentid , studentname student.

my question similar list stored functions reference table in postgresql code given there isn't working... n.nspname given in condition there related schema not table.

perhaps not precise, query should work.

select routine_schema, routine_name  information_schema.routines  routine_definition ~ 'student'  , routine_definition ~ 'studentid'  , routine_definition ~ 'studentname'; 

depending on how wrote procedure, can apply more precise regex expressions. in example, if wrote tables , columns in form: table.column use expression:

... routine_definition ~ 'student\.studentid'  , routine_definition ~ 'student\.studentname' 

Comments