pg_conversion
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