[Solved] You have a JSON column profile with nested data:{"user": {"details": {"email": "user@example.com", "phone": "12345"}}}Which query correctly extracts the email as text using the #>> operator? | PostgreSQL

PostgreSQL - JSON and JSONB

You have a JSON column profile with nested data:
{"user": {"details": {"email": "user@example.com", "phone": "12345"}}}
Which query correctly extracts the email as text using the #>> operator?

ASELECT profile #>> 'user.details.email' FROM accounts;

BSELECT profile #> '{user,details,email}' FROM accounts;

CSELECT profile->'user'->'details'->>'email' FROM accounts;

DSELECT profile #>> '{user,details,email}' FROM accounts;

Step-by-Step Solution

Solution:

Step 1: Understand the nested JSON path
The email is nested under keys user, details, then email.
Step 2: Use correct operator and path syntax
#>> extracts text and requires path as an array in braces: '{user,details,email}'.
Step 3: Evaluate other options
#> returns JSON, not text; SELECT profile->'user'->'details'->>'email' FROM accounts; uses different operators but is valid syntax; SELECT profile #>> 'user.details.email' FROM accounts; uses incorrect path format.
Final Answer:
SELECT profile #>> '{user,details,email}' FROM accounts; -> Option D
Quick Check:
Use #>> with array path in braces for text extraction [OK]

Quick Trick: Use braces with comma-separated keys for #>> path [OK]

Common Mistakes:

Using dot notation inside quotes for path
Using #> instead of #>> for text
Confusing operator syntax with -> and ->>

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

You have a JSON column profile with nested data:

Step 1: Understand the nested JSON path

Step 2: Use correct operator and path syntax

Step 3: Evaluate other options

Final Answer:

Quick Check:

Want More Practice?