JSONB

JSONB is a SQL data type in the PostgreSQL Specific category. PostgreSQL binary JSON type, more efficient than plain JSON. Supports indexing (GIN) and path queries. The syntax is column JSONB. It returns binary JSON. A typical example: CREATE TABLE logs (data JSONB); INSERT INTO logs VALUES ('{"user": "Alice", "action": "login", "ip": "192.168.1.1"}'); -- GIN index for JSONB queries: CREATE INDEX ON logs USING GIN(data); -- Query JSON path: SELECT data->>'user' FROM logs WHERE data->>'action' = 'login'; A close relative is SERIAL, which postgreSQL auto-increment type. Creates an INTEGER column with a sequence. Equivalent to AUTO_INCREMENT in MySQL. A close relative is RETURNING, which postgreSQL extension that returns values from INSERT/UPDATE/DELETE statements (like OUTPUT in SQL Server). A close relative is ARRAY, which postgreSQL supports array columns and array operations. Can be multi-dimensional. More about this category: PostgreSQL-specific features — SERIAL, RETURNING, ARRAY, JSONB, UPSERT. Related PostgreSQL Specific entries: SERIAL, RETURNING, ARRAY, UPSERT (INSERT ON CONFLICT), ILIKE, BIGSERIAL / SMALLSERIAL, GENERATED AS IDENTITY, COPY.