PLJS Types

June 25, 2025 ยท View on GitHub

In PLJS, types are converted between Postgres native types and JavaScript types. This is not always a 1:1 mapping, but where possible there are direct conversions:

PostgreSQL TypeJavaScript Type
TEXTString
VARCHARString
FLOAT4Number
FLOAT8Number
NUMERICNumber or BigInt
OIDNumber
BOOLBool
INT2Number
INT4Number or BigInt
INT8Number or BigInt
FLOAT4Number
FLOAT8Number
JSONJSON
JSONBJSON
TEXTString
VARCHARString
BPCHARString
NAMEString
XMLString
BYTEAArray
DATEDate
TIMESTAMPDate
TIMESTAMPTZOIDDate
defaultString or Number