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.
PostgreSQL 8.3.23 Documentation
Prev Fast Backward Chapter 33. The Information Schema Fast Forward Next

33.9. column_domain_usage

The view column_domain_usage identifies all columns (of a table or a view) that make use of some domain defined in the current database and owned by a currently enabled role.

Table 33-7. column_domain_usage Columns

Name Data Type Description
domain_catalog sql_identifier Name of the database containing the domain (always the current database)
domain_schema sql_identifier Name of the schema containing the domain
domain_name sql_identifier Name of the domain
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 column
Prev Home Next
check_constraints Up column_privileges