top of page
Difference between json and jsonb in PostgreSQL
PostgreSQL allows to store JSON data in json and jsonb datatype. Let’s understand the difference between json and jsonb. json jsonb json datatype was first introduced with Postgres 9.2. jsonb datatype was introduced in Postgres 9.4. json data type stores an exact copy of the input text. jsonb stores data in a decomposed binay format. json does not support indexing jsonb supports indexing [GIN (Generalized Inverted Index)] When to use json data type want to perform a lot of IN
1 min read
bottom of page