Databases · Middle · Question 33 of 75

When should you use `jsonb` columns in PostgreSQL?

✓Correct answer: For truly flexible or rarely queried attributes; core fields you filter, join or constrain on belong in regular columns
2Never; PostgreSQL can't index JSON
3For every column, because JSON is more flexible

Explanation

Regular columns get types, constraints, foreign keys and better statistics. jsonb is binary and indexable with GIN, unlike text-based json.

Further reading

PostgreSQL: JSON types ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.