Better JSON in Postgres with PostgreSQL 14 ↦
Craig Kerstiens:
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 theJSONBdatatype. 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.
Discussion
Sign in or Join to comment or subscribe