September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 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.

33.44. view_column_usage

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

Note: Columns of system tables are not included. This should be fixed sometime.

Table 33-42. view_column_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 contains the column that is used by the view (always the current database)
table_schema sql_identifier Name of the schema that contains the table that contains the column that is used by the view
table_name sql_identifier Name of the table that contains the column that is used by the view
column_name sql_identifier Name of the column that is used by the view