3rd October 2019: PostgreSQL 12 Released!
Supported Versions: Current (12) / 11 / 10 / 9.6 / 9.5 / 9.4
Development Versions: devel
Unsupported versions: 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 supported versions listed above instead.

34.62. 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 34-60. 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