pg_conversion

A system catalogue table describing encoding conversion functions

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

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 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

Categories

System catalogue

See also

CREATE CONVERSION