Contents
PLJS Types
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 |