Which of the following is the correct syntax to update the key "city" to "Paris" in a JSONB column named info using jsonb_set?

easy📝 Syntax Q3 of 15

PostgreSQL - JSON and JSONB

Which of the following is the correct syntax to update the key "city" to "Paris" in a JSONB column named info using jsonb_set?

Ajsonb_set(info, '{city}', '"Paris"')

Bjsonb_set(info, 'city', 'Paris')

Cjsonb_set(info, '{city}', 'Paris')

Djsonb_set(info, 'city', '"Paris"')

Step-by-Step Solution

Solution:

Step 1: Understand jsonb_set syntax
The second argument is a text array path, so '{city}' is correct. The new value must be a JSON string, so '"Paris"' is needed.
Step 2: Check each option
jsonb_set(info, '{city}', '"Paris"') uses correct path and properly quoted JSON string. Others either miss braces or quotes.
Final Answer:
jsonb_set(info, '{city}', '"Paris"') -> Option A
Quick Check:
Correct syntax = jsonb_set(info, '{key}', '"value"') [OK]

Quick Trick: Use braces for path and double quotes inside single quotes for value [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