Expand description
PostgreSQL type OID to Arrow DataType mapping.
Maps PostgreSQL’s internal type OIDs to Apache Arrow data types
for zero-copy CDC event conversion. Also provides text-format
value parsing for pgoutput protocol data.
Structs§
- PgColumn
- A column descriptor from a
PostgreSQLrelation.
Constants§
- BOOL_
ARRAY_ OID bool[]- 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)- CIDR_
OID cidr— IPv4/IPv6 network address- DATE_
OID date— calendar date- FLOA
T4_ ARRAY_ OID float4[]- FLOA
T4_ OID float4(real) — single precision floating-point- FLOA
T8_ ARRAY_ OID float8[]- FLOA
T8_ OID float8(double precision) — double precision floating-point- INET_
OID inet— IPv4/IPv6 host address- INT2_
ARRAY_ OID int2[]- INT2_
OID int2(smallint) — 2-byte signed integer- INT4_
ARRAY_ OID int4[]- INT4_
OID int4(integer) — 4-byte signed integer- INT8_
ARRAY_ OID int8[]- INT8_
OID int8(bigint) — 8-byte signed integer- INTERVAL_
OID interval— time interval- JSONB_
OID jsonb— binary JSON data- JSON_
OID json— JSON data- MACADDR_
OID macaddr— MAC address- 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_
ARRAY_ OID varchar[]- VARCHAR_
OID varchar— variable-length character string- XML_OID
xml— XML data
Functions§
- pg_
type_ name - Returns a human-readable name for a
PostgreSQLtype OID. - pg_
type_ to_ arrow - Maps a
PostgreSQLtype OID to an ArrowDataType.