November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12
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.
36.12. column_column_usage
Prev  Up Chapter 36. The Information Schema Home  Next

36.12. column_column_usage

The view column_column_usage identifies all generated columns that depend on another base column in the same table. Only tables owned by a currently enabled role are included.

Table 36.10. column_column_usage Columns

Name Data Type Description
table_catalog sql_identifier Name of the database containing the table (always the current database)
table_schema sql_identifier Name of the schema containing the table
table_name sql_identifier Name of the table
column_name sql_identifier Name of the base column that a generated column depends on
dependent_column sql_identifier Name of the generated column

Prev  Up  Next
36.11. collation_character_set_applicability  Home  36.13. column_domain_usage