[Solved] Which of the following is a key difference between json and jsonb data types in PostgreSQL? — Ans: jsonb stores data in a binary format, while json stores it as plain text. | PostgreSQL

PostgreSQL - JSON and JSONB

Which of the following is a key difference between json and jsonb data types in PostgreSQL?

A<code>jsonb</code> stores data in a binary format, while <code>json</code> stores it as plain text.

B<code>json</code> supports indexing, but <code>jsonb</code> does not.

C<code>jsonb</code> preserves the original formatting and whitespace, <code>json</code> does not.

D<code>json</code> is faster for querying than <code>jsonb</code>.

Step-by-Step Solution

Solution:

Step 1: Understand storage formats of json and jsonb
json stores data as plain text, preserving formatting and whitespace. jsonb stores data in a decomposed binary format optimized for processing.
Step 2: Compare indexing and querying capabilities
jsonb supports indexing and is generally faster for querying, unlike json.
Final Answer:
jsonb stores data in a binary format, while json stores it as plain text. -> Option A
Quick Check:
Storage format difference = A [OK]

Quick Trick: Remember: jsonb = binary, json = text [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is a key difference between json and jsonb data types in PostgreSQL?