35.44. routine_table_usage
routine_table_usage
The view routine_table_usage is meant to identify all tables that are used by a function or procedure.
This information is currently not tracked by PostgreSQL.
Column Type Description |
|---|
specific_catalog Name of the database containing the function (always the current database) |
specific_schema Name of the schema containing the function |
specific_name The "specific name" of the function. See routines for more information. |
routine_catalog Name of the database containing the function (always the current database) |
routine_schema Name of the schema containing the function |
routine_name Name of the function (might be duplicated in case of overloading) |
table_catalog Name of the database that contains the table that is used by the function (always the current database) |
table_schema Name of the schema that contains the table that is used by the function |
table_name Name of the table that is used by the function |
: routine_table_usage Columns