Postgres has had “JSON” support for nearly 10 years now. I put
JSONin quotes because well, 10 years ago when we announced JSON support we kinda cheated. We validated JSON was valid and then put it into a standard text field. Two years later in 2014 with Postgres 9.4 we got more proper JSON support with the
JSONBdatatype. My colleague @will likes to state that the B stands for better. In Postgres 14, the JSONB support is indeed getting way better.
A small but solid improvement to how you query
JSONB, making it more
JSON-y than ever.