JSONB has a binary format. What does this specifically allow to do for a column?

JSONB is a binary format for storing JSON in PostgreSQL. Unlike textual JSON, JSONB stores data in a binary form, which offers several advantages for working with columns:

• Fast access and search: JSONB is indexed, allowing efficient queries on nested fields.
• Size optimization: The binary format generally takes up less space than text JSON.
• Support for operators and functions: Special operators can be used to extract and filter data within JSONB.
• No need to parse text on each query, which speeds up processing.

Example of using a GIN index for JSONB:

CREATE INDEX idx_data ON my_table USING GIN (jsonb_column);

SELECT * FROM my_table WHERE jsonb_column @> '{"key": "value"}';

Thus, JSONB allows for efficient storage and quick searching within JSON structures inside a column.