Postgres Containment Operators : Part 1 — Introduction

)An unofficial guide to JSONB operators in Postgres. What is JSONB ? jsonb and json are datatypes in Postgres that can store arbitrary JSON documents. They differ primarily in the storage format - json stores data verbatim (as text) whereas jsonb stores it in a decomposed binary format, allowing the content to be indexed. jsonb has more…

This is an excerpt. The full article continues at Hasura.