[Solved] You have a JSONB column account with data:{"contact": {"phone": "9876543210", "email": "test@example.com"}}Which query correctly extracts the phone number as text using path extraction? | PostgreSQL

PostgreSQL - JSON and JSONB

You have a JSONB column account with data:
{"contact": {"phone": "9876543210", "email": "test@example.com"}}
Which query correctly extracts the phone number as text using path extraction?

ASELECT account ->> '{contact,phone}' FROM users;

BSELECT account #> '{contact,phone}' FROM users;

CSELECT account -> 'contact' ->> 'phone' FROM users;

DSELECT account #>> '{contact,phone}' FROM users;

Step-by-Step Solution

Solution:

Step 1: Identify operator for text extraction
The #>> operator extracts text at a specified path.
Step 2: Verify path syntax
The path {contact,phone} correctly targets the phone number.
Step 3: Evaluate other options
#> returns JSON, ->> does not accept path arrays, and ->> with path string is invalid.
Final Answer:
SELECT account #>> '{contact,phone}' FROM users; -> Option D
Quick Check:
Use #>> with path array for text [OK]

Quick Trick: Use #>> with path array to get text from JSONB [OK]

Common Mistakes:

Using #> instead of #>> for text
Incorrect path syntax with ->>
Confusing -> and ->> operators

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 JSONB column account with data:

Step 1: Identify operator for text extraction

Step 2: Verify path syntax

Step 3: Evaluate other options

Final Answer:

Quick Check:

Want More Practice?