Type OIDs

NodeDB maps its types to PostgreSQL OIDs for pgwire compatibility.

NodeDB TypePostgreSQL TypeOID
STRINGtext25
INTint820
FLOATfloat8701
BOOLbool16
TIMESTAMPtimestamptz1184
UUIDuuid2950
DECIMALnumeric1700
ARRAYjsonb3802
OBJECTjsonb3802
GEOMETRYbytea17

Complex types (ARRAY, OBJECT) are serialized as JSONB over pgwire. GEOMETRY is serialized as WKB (bytea).