| The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide
by The PostgreSQL Global Development Group Paperback (6"x9"), 478 pages ISBN 9781906966065 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
4.11 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 columns for details.
4-9:
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 |
| ISBN 9781906966065 | The PostgreSQL 9.0 Reference Manual - Volume 2 - Programming Guide | See the print edition |