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 16)
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 15)
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 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
The integer value contained in columns conforencoding and contencoding can be converted to a human-readable representation with the function pg_encoding_to_char().
Change history
pg_conversion has not been modified since it was added in PostgreSQL 7.3.
- PostgreSQL 7.3
- added (commit fcc96256)
References
- PostgreSQL documentation: pg_conversion
