PostgreSQL

52.55. `pg_transform`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.55. `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 52.55. pg_transform Columns

Name Type References Description

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.

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
52.54. `pg_tablespace`	Home	52.56. `pg_trigger`

52.54. pg_tablespace

Home

52.56. pg_trigger

PostgreSQL

52.55. pg_transform

52.55. `pg_transform`