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

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

> Note: System tables are not included. This should be fixed sometime.

Table 32-38. 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 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 | Home | Next
view_column_usage | Up | views