JSONB

A PostgreSQL column type that stores a JSON document in a parsed binary form you can index and query into.

In more detail

JSONB validates the document on the way in and lets queries reach inside it, which the plain text form cannot do efficiently. SQLite has no such type; it stores JSON as text and offers functions to read it.

Example

attributes JSONB

Related terms

Taught in

References