PostgreSQL
37.62. view_routine_usage
The view view_routine_usage identifies all routines (functions and procedures) that are used in the query expression of a view (the SELECT statement that defines the view). A routine is only included if that routine is owned by a currently enabled role.
Table 37.60. view_routine_usage Columns
| Name | Data Type | Description |
|---|---|---|
|
|
Name of the database containing the view (always the current database) |
|
|
Name of the schema containing the view |
|
|
Name of the view |
|
|
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.40 for more information. |
+
| Prev | Up | Next |
|---|---|---|
37.61. |
37.63. |
Copyright © 1996-2023 The PostgreSQL Global Development Group