↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

pg_conversion

Read the PG 18 manual

The catalog pg_conversion describes encoding conversion functions.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

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

Columns 8

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
connamenameNOT NULLConversion name (unique within a namespace)
connamespaceoidNOT NULLThe OID of the namespace that contains this conversion
pg_namespace.oid
conowneroidNOT NULLOwner of the conversion
pg_authid.oid
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
pg_proc.oid
condefaultboolNOT NULLTrue if this is the default conversion
Column history across versions
Version history 6
  1. 14 → 15 reworded
  2. 11 → 12 changed
  3. 10 → 11 reworded
  4. 9.0 → 9.1 reworded
  5. 8.0 → 8.1 changed
  6. 7.4 → 8.0 reworded

Definition snapshot: english-manuals:720b4c407d8bf23174e31ba7dff… · English manual source