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
Historical version. PostgreSQL 9.6 reached end of support in November 2021. See the current version for supported releases.

50.48. pg_transform

The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM for more information.

Table 50-48. pg_transform Columns

Name Type References Description
trftype oid pg_type.oid OID of the data type this transform is for
trflang oid pg_language.oid OID of the language this transform is for
trffromsql regproc pg_proc.oid The OID of the function to use when converting the data type for input to the procedural language (e.g., function parameters). Zero is stored if this operation is not supported.
trftosql regproc pg_proc.oid The OID of the function to use when converting output from the procedural language (e.g., return values) to the data type. Zero is stored if this operation is not supported.

Report a documentation issue

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