Dependency list

Suggest edits

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

Could this page be better? Report a problem or suggest an addition!