PostgreSQL
37.40. routine_column_usage #
The view routine_column_usage identifies all columns that are used by a function or procedure, either in the SQL body or in parameter default expressions. (This only works for unquoted SQL bodies, not quoted bodies or functions in other languages.) A column is only included if its table is owned by a currently enabled role.
Table 37.38. routine_column_usage Columns
| Column Type Description |
|---|
Name of the database containing the function (always the current database) |
Name of the schema containing the function |
The “[.quote]#specific name”# of the function. See Section 37.45 for more information. |
Name of the database containing the function (always the current database) |
Name of the schema containing the function |
Name of the function (might be duplicated in case of overloading) |
Name of the database that contains the table that is used by the function (always the current database) |
Name of the schema that contains the table that is used by the function |
Name of the table that is used by the function |
Name of the column that is used by the function |
+
| Prev | Up | Next |
|---|---|---|
37.39. |
37.41. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2024 The PostgreSQL Global Development Group