How to JSON in PostgreSQL®

How to index and query a JSON object in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB. This doc showcases how to index a JSONB column with a GIN index.

How to check if JSON contains in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides several different ways to check if a value/field from a JSON document:

What are the differences between JSON or JSONB in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data:

JSON stores the JSON as text, performing a validation on the correctness of the JSON syntax
JSONB optimizes the JSON storage in a custom binary format. Therefore, on top of validating the correctness of the JSON format, time is spent to properly parse and store the content.