What does the PostgreSQL operator #> do when used with JSON data?

easy📝 Conceptual Q11 of 15

PostgreSQL - JSON and JSONB

What does the PostgreSQL operator #> do when used with JSON data?

ADeletes JSON data at a specified path

BExtracts text at a specified path

CExtracts JSON data at a specified path

DUpdates JSON data at a specified path

Step-by-Step Solution

Solution:

Step 1: Understand the operator #>
This operator extracts JSON data from a JSON column or value at the given path as JSON type.
Step 2: Compare with similar operator #>>
The #>> operator extracts text, not JSON, at the path.
Final Answer:
Extracts JSON data at a specified path -> Option C
Quick Check:
#> extracts JSON data [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

Want More Practice?

15+ quiz questions · All difficulty levels · Free