September 25, 2025: PostgreSQL 18 Released!
Supported Versions: Current (18) / 17 / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
51.56. pg_transform
Prev  Up Chapter 51. System Catalogs Home  Next

51.56. 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 51.56. 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.

Prev  Up  Next
51.55. pg_tablespace  Home  51.57. pg_trigger