Skip to main content

Module types

Module types 

Source
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 PostgreSQL relation.

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
FLOAT4_OID
float4 (real) — single precision floating-point
FLOAT8_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 PostgreSQL type OID.