[Solved] In PostgreSQL, what does the operator -> do when applied to a JSON column? — Ans: Extracts the JSON object field by key as JSON | PostgreSQL

PostgreSQL - JSON and JSONB

In PostgreSQL, what does the operator -> do when applied to a JSON column?

AExtracts the JSON object field by key as text

BExtracts the JSON object field by key as JSON

CConverts JSON to text

DDeletes a key from JSON object

Step-by-Step Solution

Solution:

Step 1: Understand the operator -> in PostgreSQL JSON
The -> operator extracts a JSON object field by key and returns it as JSON type.
Step 2: Compare with other operators
The ->> operator extracts the field as text, not JSON. The other options describe unrelated operations.
Final Answer:
Extracts the JSON object field by key as JSON -> Option B
Quick Check:
-> operator = Extract JSON field as JSON [OK]

Quick Trick: Use -> for JSON output, ->> for text output [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

In PostgreSQL, what does the operator -> do when applied to a JSON column?