Postgresql 中文操作指南

37.65. view_table_usage #

视图 view_table_usage 识别视图的查询表达式（定义视图的 SELECT 语句）中使用的所有表。仅当表为当前启用的角色所有时，才会包含该表。

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.63. view_table_usage Columns

Column 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