PostgreSQL :: Tecnisys Docs

37.65. `view_table_usage`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.65. `view_table_usage`

The view view_table_usage identifies all tables that are used in the query expression of a view (the SELECT statement that defines the view). A table is only included if that table is owned by a currently enabled role.

Note

System tables are not included. This should be fixed sometime.

Table 37.63. view_table_usage Columns

Column Type Description

Column Type Description
`view_catalog` `sql_identifier` Name of the database that contains the view (always the current database)
`view_schema` `sql_identifier` Name of the schema that contains the view
`view_name` `sql_identifier` Name of the view
`table_catalog` `sql_identifier` Name of the database that contains the table that is used by the view (always the current database)
`table_schema` `sql_identifier` Name of the schema that contains the table that is used by the view
`table_name` `sql_identifier` Name of the table that is used by the view

view_catalog sql_identifier

Name of the database that contains the view (always the current database)

view_schema sql_identifier

Name of the schema that contains the view

view_name sql_identifier

Name of the view

table_catalog sql_identifier

Name of the database that contains the table that is used by the view (always the current database)

table_schema sql_identifier

Name of the schema that contains the table that is used by the view

table_name sql_identifier

Name of the table that is used by the view

Prev	Up	Next
37.64. `view_routine_usage`	Home	37.66. `views`

Home

37.66. views

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.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

PostgreSQL

37.65. view_table_usage

Note

Submit correction

37.65. `view_table_usage`