↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

pg_transform

Read the PG 18 manual

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

Reading PG 18current·documented in 13 of 24 versions, 9.5 to 20

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

Columns 5

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
trftypeoidNOT NULLOID of the data type this transform is for
pg_type.oid
trflangoidNOT NULLOID of the language this transform is for
pg_language.oid
trffromsqlregprocNOT NULLThe 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
trftosqlregprocNOT NULLThe 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 4
  1. 13 → 14 reworded
  2. 12 → 13 reworded
  3. 11 → 12 changed
  4. 9.4 → 9.5 added

Definition snapshot: english-manuals:8bc748ae27ad9c90237eacc09d8… · English manual source