Dependency list

The function spl_show_dependency_tb shows all the functions, operators, and relations used inside a processed function. For example:

SELECT * FROM spl_show_dependency_tb('testfunc(int,float)');

Output

│   type   │  oid  │ schema │  name   │           params           │
|----------|-------|--------|---------|----------------------------|
│ FUNCTION │ 36008 │ public │ myfunc1 │ (integer,double precision) │
│ FUNCTION │ 35999 │ public │ myfunc2 │ (integer,double precision) │
│ OPERATOR │ 36007 │ public │ **      │ (integer,integer)          │
│ RELATION │ 36005 │ public │ myview  │                            │
│ RELATION │ 36002 │ public │ mytable │                            │
(4 rows)

Optional arguments for spl_show_dependency_tb include:

relid
anyelementtype
enumtype
anyrangetype
anycompatibletype
anycompatiblerangetype