The view domain_udt_usage identifies all columns that use data types owned by the current user. Note that in PostgreSQL, built-in data types behave like user-defined types, so they are included here as well.
Table 31-12. 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 |
