PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_conversion

Read PG 18 manual ↗

The catalog pg_conversion describes encoding conversion functions.

Kind: System catalogs
Columns in this snapshot: 8
Definition source: English manual

Columns 8

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`conname`	`name`	Conversion name (unique within a namespace)
`connamespace`	`oid`	The OID of the namespace that contains this conversion pg_namespace.oid
`conowner`	`oid`	Owner of the conversion pg_authid.oid
`conforencoding`	`int4`	Source encoding ID (pg_encoding_to_char() can translate this number to the encoding name)
`contoencoding`	`int4`	Destination encoding ID (pg_encoding_to_char() can translate this number to the encoding name)
`conproc`	`regproc`	Conversion function pg_proc.oid
`condefault`	`bool`	True if this is the default conversion

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`conname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`connamespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`conowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`conforencoding`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`contoencoding`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`conproc`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`condefault`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 5

Definition snapshot: english-manuals:5f894981d1ad103e76f1a70c655… · English manual source