November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
37.63. view_table_usage
Prev  Up Chapter 37. The Information Schema Home  Next

37.63. 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.61. view_table_usage Columns

Name Data 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

Prev  Up  Next
37.62. view_routine_usage  Home  37.64. views