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
Post a Comment