The view column_udt_usage identifies all columns that use 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. See also Section 34.16 for details.

Table 34-13. column_udt_usage Columns

Name

Data Type

Description

udt_catalog

sql_identifier

Name of the database that the column data type (the underlying type of the domain, if applicable) is defined in (always the current database)

udt_schema

sql_identifier

Name of the schema that the column data type (the underlying type of the domain, if applicable) is defined in

udt_name

sql_identifier

Name of the column data type (the underlying type of the domain, if applicable)

table_catalog

sql_identifier

Name of the database containing the table (always the current database)

Submit correction

If you see anything in the documentation that is not correct, does not match
your experience with the particular feature or requires further clarification,
please use
this form
to report a documentation issue.