pg_cast

PostgreSQL 7.3.4 Documentation
Prev | Chapter 3. System Catalogs | Next

# 3.8. pg_cast

`pg_cast` stores data type conversion paths, both built-in paths and those defined with `CREATE CAST`.

Table 3-8. pg_cast Columns

Name | Type | References | Description
--- | --- | --- | ---
castsource | `oid` | pg_type.oid | OID of the source data type
casttarget | `oid` | pg_type.oid | OID of the target data type
castfunc | `oid` | pg_proc.oid | The OID of the function to use to perform this cast. Zero is stored if the data types are binary coercible (that is, no run-time operation is needed to perform the cast).
castcontext | `char` |  | Indicates what contexts the cast may be invoked in. e means only as an explicit cast (using CAST, ::, or function-call 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.

Prev | Home | Next
pg_attribute | Up | pg_class