↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / System Catalogs

pg_conversion

The catalog pg_conversion describes encoding conversion functions. See CREATE CONVERSION for more information.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

kind
catalog
lang
en
measured attributes
true
metadata release
18.6
runtime columns
oid, conname, connamespace, conowner, conforencoding, contoencoding, conproc, condefault
runtime verified
false
source
english-manual

Definition PG 18

The catalog pg_conversion describes encoding conversion functions. See CREATE CONVERSION for more information.

Catalog columns

ColumnTypeNullabilityDescription
oidoidNot nullRow identifier
connamenameNot nullConversion name (unique within a namespace)
connamespaceoidNot nullThe OID of the namespace that contains this conversion
conowneroidNot nullOwner of the conversion
conforencodingint4Not nullSource encoding ID (pg_encoding_to_char() can translate this number to the encoding name)
contoencodingint4Not nullDestination encoding ID (pg_encoding_to_char() can translate this number to the encoding name)
conprocregprocNot nullConversion function
condefaultboolNot nullTrue if this is the default conversion

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:4075f76402b6a0c1dd9724f55de925d5e4ae57054bf802cd89dc171a38a61c90

Text language: en · catalog-bilingual-repair:4075f76402b6a0c1dd9724f55de925d5e4ae57054bf802cd89dc171a38a61c90