Which of the following is the correct syntax to insert JSON data into a table named users with a jsonb column info?

easy📝 Syntax Q12 of 15

PostgreSQL - JSON and JSONB

Which of the following is the correct syntax to insert JSON data into a table named users with a jsonb column info?

AINSERT INTO users (info) VALUES (jsonb '{"city": "NY", "zip": 10001}');

BINSERT INTO users (info) VALUES ('{city: "NY", zip: 10001}');

CINSERT INTO users (info) VALUES ("{'city': 'NY', 'zip': 10001}");

DINSERT INTO users (info) VALUES (jsonb '{city: NY, zip: 10001}');

Step-by-Step Solution

Solution:

Step 1: Use jsonb type cast for jsonb columns
When inserting into a jsonb column, you can cast the string to jsonb using jsonb '...' .
Step 2: Use valid JSON string with double quotes inside single quotes
The JSON must be valid with double quotes around keys and string values.
Final Answer:
INSERT INTO users (info) VALUES (jsonb '{"city": "NY", "zip": 10001}'); -> Option A
Quick Check:
jsonb cast with valid JSON string = C [OK]

Quick Trick: Cast JSON string to jsonb with jsonb '...' for jsonb columns [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