Given a JSON column settings with value {"theme": {"colors": {"background": "#fff"}}}, which query extracts the background color as JSON, and which extracts it as text?

hard📝 Application Q9 of 15

PostgreSQL - JSON and JSONB

Given a JSON column settings with value {"theme": {"colors": {"background": "#fff"}}}, which query extracts the background color as JSON, and which extracts it as text?

AJSON: settings #> '{theme,colors,background}'; Text: settings #>> '{theme,colors,background}'

BJSON: settings #>> '{theme,colors,background}'; Text: settings #> '{theme,colors,background}'

CJSON: settings -> 'theme' -> 'colors' -> 'background'; Text: settings ->> 'background'

DJSON: settings ->> '{theme,colors,background}'; Text: settings -> '{theme,colors,background}'

Step-by-Step Solution

Solution:

Step 1: Identify JSON extraction operator
#> extracts JSON value at path array.
Step 2: Identify text extraction operator
#>> extracts text value at path array.
Step 3: Verify options
JSON: settings #> '{theme,colors,background}'; Text: settings #>> '{theme,colors,background}' correctly uses #> for JSON and #>> for text extraction with path arrays.
Final Answer:
JSON: settings #> '{theme,colors,background}'; Text: settings #>> '{theme,colors,background}' -> Option A
Quick Check:
#> = JSON, #>> = text with path [OK]

Quick Trick: Use #> for JSON, #>> for text with paths [OK]

Common Mistakes:

Swapping #> and #>>
Using -> and ->> with path arrays
Incorrect path syntax

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

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

Given a JSON column settings with value {"theme": {"colors": {"background": "#fff"}}}, which query extracts the background color as JSON, and which extracts it as text?

Step 1: Identify JSON extraction operator

Step 2: Identify text extraction operator

Step 3: Verify options

Final Answer:

Quick Check:

Want More Practice?