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 JSONBRelated terms
- JSON — A simple text format for structured data made of keys, values, lists and nested objects.
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
- data type — The kind of a value, such as a whole number, text or a date, which decides what you can do with it and how it compares and sorts.
Taught in
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling