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 o
Chandan Rajpurohit
Jan 20, 20241 min read
bottom of page