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.