JSON primitive types and corresponding PostgreSQL types
A table describing JSON
primitive types and corresponding PostgreSQL
types.
JSON primitive type |
PostgreSQL type | Notes |
---|---|---|
string |
text | \u0000 is disallowed, as are non-ASCII Unicode escapes if database encoding
is not UTF8. |
number |
numeric | NaN and infinity values are disallowed. |
boolean |
boolean | Only lowercase true and false spelling is allowed. |
null |
n/a | SQL NULL is a different concept. |
When converting textual JSON
input into jsonb
, the primitive
types described by RFC 7159 are effectively mapped onto native PostgreSQL types.