PostgreSQL · Type Alias

jsonb

PostgreSQL provides json and jsonb for valid JSON values. json keeps the input text, while jsonb stores a decomposed form that is usually faster to process and can be indexed.

Last updated 2 November 2026

jsonb
json
CREATE INDEX name ON table USING GIN (jsonb_column);

Source: PostgreSQL: Documentation: 18: 8.14. JSON Types. Checked 2026-11-03.