select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages.

Kind
System catalogs
Columns in this snapshot
5
Definition source
English manual

Columns 5

ColumnTypeDescription / reference
oidoidRow identifier
trftypeoidOID of the data type this transform is for
pg_type.oid
trflangoidOID of the language this transform is for
pg_language.oid
trffromsqlregprocThe 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.
pg_proc.oid
trftosqlregprocThe 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.
pg_proc.oid
Column history across versions
Version history 3
  1. PG 13 → 14changed
  2. PG 12 → 13changed
  3. PG 9.4 → 9.5added

Definition snapshot: english-manuals:b40849b4d2f841e50486639a2f7… · English manual source