What does 'b' stand for in PostgreSQL's JSONB data type?
5
votes
2
answers
1054
views
While not a technical question per se, I'm curious about the actual meaning of _b_ in PostgreSQL's
jsonb
data type.
I skimmed through the official documentation but I couldn't figure it out. As far I can tell, there is no explicit mention of what _b_ actually means.
One would assume that it stands for _binary_, since that is one of the main differences between jsonb
and plain-old json
. Most articles and LLM-generated responses take for granted that it means _binary_. I've found articles , however, that refer to it as _better_.
According to the official documentation, jsonb
is more than just a binary encoding of a JSON object, therefore, _better_ might be a slightly more fitting description.
Does anybody know the story behind jsonb
's naming?
Asked by Sotosoul
(103 rep)
Jul 17, 2025, 11:23 AM
Last activity: Jul 21, 2025, 08:09 PM
Last activity: Jul 21, 2025, 08:09 PM