PostgreSQL

37.55. `transforms`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.55. `transforms`

The view transforms contains information about the transforms defined in the current database. More precisely, it contains a row for each function contained in a transform (the “[.quote]#from SQL”# or “[.quote]#to SQL”# function).

Table 37.53. transforms Columns

Column Type Description

Column Type Description
`udt_catalog` `sql_identifier` Name of the database that contains the type the transform is for (always the current database)
`udt_schema` `sql_identifier` Name of the schema that contains the type the transform is for
`udt_name` `sql_identifier` Name of the type the transform is for
`specific_catalog` `sql_identifier` Name of the database containing the function (always the current database)
`specific_schema` `sql_identifier` Name of the schema containing the function
`specific_name` `sql_identifier` The “[.quote]#specific name”# of the function. See Section 37.45 for more information.
`group_name` `sql_identifier` The SQL standard allows defining transforms in “[.quote]#groups”#, and selecting a group at run time. PostgreSQL does not support this. Instead, transforms are specific to a language. As a compromise, this field contains the language the transform is for.
`transform_type` `character_data` `FROM SQL` or `TO SQL`

udt_catalog sql_identifier

Name of the database that contains the type the transform is for (always the current database)

udt_schema sql_identifier

Name of the schema that contains the type the transform is for

udt_name sql_identifier

Name of the type the transform is for

specific_catalog sql_identifier

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

specific_schema sql_identifier

Name of the schema containing the function

specific_name sql_identifier

The “[.quote]#specific name”# of the function. See Section 37.45 for more information.

group_name sql_identifier

The SQL standard allows defining transforms in “[.quote]#groups”#, and selecting a group at run time. PostgreSQL does not support this. Instead, transforms are specific to a language. As a compromise, this field contains the language the transform is for.

transform_type character_data

FROM SQL or TO SQL

Prev	Up	Next
37.54. `tables`	Home	37.56. `triggered_update_columns`

37.54. tables

Home

37.56. triggered_update_columns

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.

PostgreSQL

37.55. transforms

Submit correction

37.55. `transforms`