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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, trftype, trflang, trffromsql, trftosql
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| trftype | oid | Not null | OID of the data type this transform is for |
| trflang | oid | Not null | OID of the language this transform is for |
| trffromsql | regproc | Not null | 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 the default behavior should be used. |
| trftosql | regproc | Not null | 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 the default behavior should be used. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:e0b92be041827e8be602a2619bf08c22f747bf3598b75429d4a8830b6fbfb4b1
Text language: en · catalog-bilingual-repair:e0b92be041827e8be602a2619bf08c22f747bf3598b75429d4a8830b6fbfb4b1