Contents

pg_conversion

A system table describing encoding conversion functions

pg_conversion is a system catalogue table which describes encoding conversion functions.

pg_conversion was added in PostgreSQL 7.3.

Source code

Between PostgreSQL 8.4 (commit 039dfbfd) and PostgreSQL 11 (commit cefa3871), an additional source file src/include/catalog/pg_conversion_fn.h existed to enable catalogue definitions to be included by frontend code.

Definition by PostgreSQL version

pg_conversion (PostgreSQL 14)

             Table "pg_catalog.pg_conversion"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 conname        | name    |           | not null | 
 connamespace   | oid     |           | not null | 
 conowner       | oid     |           | not null | 
 conforencoding | integer |           | not null | 
 contoencoding  | integer |           | not null | 
 conproc        | regproc |           | not null | 
 condefault     | boolean |           | not null | 
Indexes:
    "pg_conversion_oid_index" PRIMARY KEY, btree (oid)
    "pg_conversion_default_index" UNIQUE CONSTRAINT, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE CONSTRAINT, btree (conname, connamespace)

Documentation: pg_conversion

pg_conversion (PostgreSQL 13)

             Table "pg_catalog.pg_conversion"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 conname        | name    |           | not null | 
 connamespace   | oid     |           | not null | 
 conowner       | oid     |           | not null | 
 conforencoding | integer |           | not null | 
 contoencoding  | integer |           | not null | 
 conproc        | regproc |           | not null | 
 condefault     | boolean |           | not null | 
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 12)

             Table "pg_catalog.pg_conversion"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 oid            | oid     |           | not null | 
 conname        | name    |           | not null | 
 connamespace   | oid     |           | not null | 
 conowner       | oid     |           | not null | 
 conforencoding | integer |           | not null | 
 contoencoding  | integer |           | not null | 
 conproc        | regproc |           | not null | 
 condefault     | boolean |           | not null | 
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 11)

             Table "pg_catalog.pg_conversion"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 conname        | name    |           | not null | 
 connamespace   | oid     |           | not null | 
 conowner       | oid     |           | not null | 
 conforencoding | integer |           | not null | 
 contoencoding  | integer |           | not null | 
 conproc        | regproc |           | not null | 
 condefault     | boolean |           | not null | 
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 10)

             Table "pg_catalog.pg_conversion"
     Column     |  Type   | Collation | Nullable | Default 
----------------+---------+-----------+----------+---------
 conname        | name    |           | not null | 
 connamespace   | oid     |           | not null | 
 conowner       | oid     |           | not null | 
 conforencoding | integer |           | not null | 
 contoencoding  | integer |           | not null | 
 conproc        | regproc |           | not null | 
 condefault     | boolean |           | not null | 
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.6)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.5)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.4)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.3)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.2)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.1)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 9.0)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 8.4)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 8.3)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

pg_conversion (PostgreSQL 8.2)

   Table "pg_catalog.pg_conversion"
     Column     |  Type   | Modifiers 
----------------+---------+-----------
 conname        | name    | not null
 connamespace   | oid     | not null
 conowner       | oid     | not null
 conforencoding | integer | not null
 contoencoding  | integer | not null
 conproc        | regproc | not null
 condefault     | boolean | not null
Indexes:
    "pg_conversion_default_index" UNIQUE, btree (connamespace, conforencoding, contoencoding, oid)
    "pg_conversion_name_nsp_index" UNIQUE, btree (conname, connamespace)
    "pg_conversion_oid_index" UNIQUE, btree (oid)

Documentation: pg_conversion

Change history

pg_conversion has not been modified since it was added in PostgreSQL 7.3.

Categories

System catalogue

See also

CREATE CONVERSION