[Solved] What does the PostgreSQL operator ->> do when used on a JSON column? — Ans: Extracts the value as text from a JSON object by key | PostgreSQL

PostgreSQL - JSON and JSONB

What does the PostgreSQL operator ->> do when used on a JSON column?

AConverts the entire JSON object to text

BExtracts the value as JSON from a JSON object by key

CExtracts the value as text from a JSON object by key

DDeletes a key from the JSON object

Step-by-Step Solution

Solution:

Step 1: Understand the ->> operator
The ->> operator extracts the value of a key from a JSON object and returns it as plain text.
Step 2: Compare with -> operator
The -> operator returns the value as JSON, not text. So ->> is used when text output is needed.
Final Answer:
Extracts the value as text from a JSON object by key -> Option C
Quick Check:
->> returns text [OK]

Quick Trick: Remember: -> returns JSON, ->> returns text [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does the PostgreSQL operator ->> do when used on a JSON column?