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 Type | JavaScript Type |
|---|---|
TEXT | String |
VARCHAR | String |
FLOAT4 | Number |
FLOAT8 | Number |
NUMERIC | Number or BigInt |
OID | Number |
BOOL | Bool |
INT2 | Number |
INT4 | Number or BigInt |
INT8 | Number or BigInt |
FLOAT4 | Number |
FLOAT8 | Number |
JSON | JSON |
JSONB | JSON |
TEXT | String |
VARCHAR | String |
BPCHAR | String |
NAME | String |
XML | String |
BYTEA | Array |
DATE | Date |
TIMESTAMP | Date |
TIMESTAMPTZOID | Date |
| default | String or Number |