Skip to content
masterclass Buddy
Start learning

PostgreSQL · Type Alias

text

PostgreSQL has json and jsonb types for valid JSON. json preserves input text; jsonb uses a decomposed form that is usually faster to query and supports indexing.

Last updated

Syntax

json
jsonb
jsonpath

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • json
  • jsonb
  • jsonpath
  • @>
  • ?
  • jsonb indexing
  • JSON processing functions and operators

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