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 / 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.
36.21. domain_udt_usage
Prev  Up Chapter 36. The Information Schema Home  Next

36.21. domain_udt_usage

The view domain_udt_usage identifies all domains that are based on data types owned by a currently enabled role. Note that in PostgreSQL, built-in data types behave like user-defined types, so they are included here as well.

Table 36.19. domain_udt_usage Columns

Name Data Type Description
udt_catalog sql_identifier Name of the database that the domain data type is defined in (always the current database)
udt_schema sql_identifier Name of the schema that the domain data type is defined in
udt_name sql_identifier Name of the domain data type
domain_catalog sql_identifier Name of the database that contains the domain (always the current database)
domain_schema sql_identifier Name of the schema that contains the domain
domain_name sql_identifier Name of the domain

Prev  Up  Next
36.20. domain_constraints  Home  36.22. domains