pg_transform

A system catalogue table storing information about transformations between data types and procedural languages

pg_transform is a system catalogue table storing information about transformations between data types and procedural languages.

pg_transform was added in PostgreSQL 9.5 (commit cac76582).

Definition by PostgreSQL version

pg_transform (PostgreSQL 13)

            Table "pg_catalog.pg_transform"
   Column   |  Type   | Collation | Nullable | Default
------------+---------+-----------+----------+---------
 oid        | oid     |           | not null |
 trftype    | oid     |           | not null |
 trflang    | oid     |           | not null |
 trffromsql | regproc |           | not null |
 trftosql   | regproc |           | not null |
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

pg_transform (PostgreSQL 12)

            Table "pg_catalog.pg_transform"
   Column   |  Type   | Collation | Nullable | Default
------------+---------+-----------+----------+---------
 oid        | oid     |           | not null |
 trftype    | oid     |           | not null |
 trflang    | oid     |           | not null |
 trffromsql | regproc |           | not null |
 trftosql   | regproc |           | not null |
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

pg_transform (PostgreSQL 11)

            Table "pg_catalog.pg_transform"
   Column   |  Type   | Collation | Nullable | Default
------------+---------+-----------+----------+---------
 trftype    | oid     |           | not null |
 trflang    | oid     |           | not null |
 trffromsql | regproc |           | not null |
 trftosql   | regproc |           | not null |
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

pg_transform (PostgreSQL 10)

            Table "pg_catalog.pg_transform"
   Column   |  Type   | Collation | Nullable | Default
------------+---------+-----------+----------+---------
 trftype    | oid     |           | not null |
 trflang    | oid     |           | not null |
 trffromsql | regproc |           | not null |
 trftosql   | regproc |           | not null |
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

pg_transform (PostgreSQL 9.6)

 Table "pg_catalog.pg_transform"
   Column   |  Type   | Modifiers
------------+---------+-----------
 trftype    | oid     | not null
 trflang    | oid     | not null
 trffromsql | regproc | not null
 trftosql   | regproc | not null
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

pg_transform (PostgreSQL 9.5)

 Table "pg_catalog.pg_transform"
   Column   |  Type   | Modifiers
------------+---------+-----------
 trftype    | oid     | not null
 trflang    | oid     | not null
 trffromsql | regproc | not null
 trftosql   | regproc | not null
Indexes:
    "pg_transform_oid_index" UNIQUE, btree (oid)
    "pg_transform_type_lang_index" UNIQUE, btree (trftype, trflang)
    

Documentation: pg_transform

Change history

This table has not been modified since it was first added in PostgreSQL 9.5.

Examples

Entry created after installing hstore_plperl:

postgres=# CREATE EXTENSION hstore_plperl CASCADE;
NOTICE:  installing required extension "hstore"
NOTICE:  installing required extension "plperl"
CREATE EXTENSION

postgres=# SELECT * FROM pg_transform;
  oid  | trftype | trflang |    trffromsql    |     trftosql     
-------+---------+---------+------------------+------------------
 16589 |   16457 |   16585 | hstore_to_plperl | plperl_to_hstore
(1 row)

Categories

Procedural language, System catalogue

See also

CREATE TRANSFORM