PostgreSQL 7.4beta4 Documentation
Prev | Fast Backward | Chapter 32. The Information Schema | Fast Forward | Next

# 32.39. 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 current user is the owner of the table that contains the column.

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

Table 32-37. 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

Prev | Home | Next
usage_privileges | Up | view_table_usage