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

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_cast

Read PG 18 manual ↗

The catalog pg_cast stores data type conversion paths, both built-in and user-defined.

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

Columns 6

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`castsource`	`oid`	OID of the source data type pg_type.oid
`casttarget`	`oid`	OID of the target data type pg_type.oid
`castfunc`	`oid`	The OID of the function to use to perform this cast. Zero is stored if the cast method doesn't require a function. pg_proc.oid
`castcontext`	`char`	Indicates what contexts the cast can be invoked in. e means only as an explicit cast (using CAST or :: syntax). a means implicitly in assignment to a target column, as well as explicitly. i means implicitly in expressions, as well as the other cases.
`castmethod`	`char`	Indicates how the cast is performed. f means that the function specified in the castfunc field is used. i means that the input/output functions are used. b means that the types are binary-coercible, thus no conversion is required.

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`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`castsource`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`casttarget`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`castfunc`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`castcontext`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`castmethod`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 4

Definition snapshot: english-manuals:197c53ad24ef7329468e1185b5d… · English manual source