Expand description
PostgreSQL column types admitted by CDC and their Arrow bindings.
Every supported type has one lossless text-to-Arrow conversion shared by the initial
snapshot and pgoutput, so a row read either way decodes to the same Arrow value.
Types without such a conversion are rejected at binding time; nothing falls back to text.
Structs§
- PgColumn
- A column descriptor from a
PostgreSQLrelation.
Constants§
- BOOL_
OID bool— boolean- BPCHAR_
OID bpchar— fixed-length character (char(n))- BYTEA_
OID bytea— variable-length binary string- CHAR_
OID char— single character (internal type)- DATE_
OID date— calendar date- FLOA
T4_ OID float4(real) — single precision floating-point- FLOA
T8_ OID float8(double precision) — double precision floating-point- INT2_
OID int2(smallint) — 2-byte signed integer- INT4_
ARRAY_ OID int4[]- INT4_
OID int4(integer) — 4-byte signed integer- INT8_
OID int8(bigint) — 8-byte signed integer- INTERVAL_
OID interval— time interval- JSONB_
OID jsonb— binary JSON data- JSON_
OID json— JSON data- NAME_
OID name— 63-byte internal name type- NUMERIC_
OID numeric— exact numeric with arbitrary precision- OID_OID
oid— object identifier (unsigned 4 bytes)- TEXT_
ARRAY_ OID text[]- TEXT_
OID text— variable-length text- TIMESTAMPTZ_
OID timestamptz— date and time with timezone- TIMESTAMP_
OID timestamp— date and time (without timezone)- TIME_
OID time— time of day (without timezone)- UUID_
OID uuid— universally unique identifier- VARCHAR_
OID varchar— variable-length character string
Functions§
- pg_
type_ name - Returns a human-readable name for a
PostgreSQLtype OID.