↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 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
Historical version. PostgreSQL 9.4 reached end of support in February 2020. See the current version for supported releases.
PostgreSQL 9.4.26 Documentation
Prev Up Chapter 34. The Information Schema Next

34.15. column_udt_usage

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)
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
column_privileges Up columns

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.