What is the key difference between JSON and JSONB?

Question

Accepted Answer

JSON stores the exact text while JSONB stores a parsed binary form that is faster to query — JSON keeps the input text verbatim (fast to write, slow to query); JSONB parses into a binary format supporting indexing and containment operators — the usual default choice. JSONB is anything but deprecated, both nest arbitrarily, and both validate — JSONB additionally normalizes duplicates and whitespace.

Answer

JSON is the standard type while JSONB is deprecated in favor of the newer jsonpath

Answer

JSON allows nested objects while JSONB is limited to flat key-value documents

Answer

JSON validates the document while JSONB accepts any text without checking it

What is the key difference between JSON and JSONB?

Why this is the answer

More PostgreSQL in Practice flashcards