1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
# 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` |
|
