Which of the following is the correct syntax to query a JSON field named data to get the value of key name in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - JSON and JSONB

Which of the following is the correct syntax to query a JSON field named data to get the value of key name in PostgreSQL?

ASELECT data->name FROM table_name;

BSELECT data['name'] FROM table_name;

CSELECT data.name FROM table_name;

DSELECT data->>'name' FROM table_name;

Step-by-Step Solution

Solution:

Step 1: Recall JSON operators in PostgreSQL
PostgreSQL uses ->> to get JSON text value by key.
Step 2: Match correct syntax
SELECT data->>'name' FROM table_name; uses data->>'name' which extracts the text value of key 'name'.
Final Answer:
SELECT data->>'name' FROM table_name; -> Option D
Quick Check:
JSON text extraction = ->> operator [OK]

Quick Trick: Use ->> to get JSON text value by key [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