AINSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": ["search", "export"]}'::jsonb);
BINSERT INTO configs (settings) VALUES (to_jsonb('{"theme": "dark", "features": [search, export]}'));
CINSERT INTO configs (settings) VALUES ('{"theme": dark, "features": ["search", "export"]}');
DINSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": "search, export"}'::jsonb);
Step-by-Step Solution
Solution:
Step 1: Validate JSON syntax
INSERT INTO configs (settings) VALUES ('{"theme": dark, "features": ["search", "export"]}'::jsonb); has incorrect JSON with unquoted "dark" string. INSERT INTO configs (settings) VALUES (to_jsonb('{"theme": "dark", "features": [search, export]}')); misses quotes around array elements. INSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": ["search", "export"]}'::jsonb); has correct JSON with quoted strings and array syntax. INSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": "search, export"}'::jsonb); stores array as a string, not an array.
Step 2: Confirm correct insertion
INSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": ["search", "export"]}'::jsonb); casts the valid JSON string to jsonb correctly.
Final Answer:
INSERT INTO configs (settings) VALUES ('{"theme": "dark", "features": ["search", "export"]}'::jsonb); -> Option A
Quick Check:
Insert nested JSON arrays with proper quotes and cast [OK]
Quick Trick:Always quote strings inside JSON arrays and cast to jsonb [OK]
Common Mistakes:
Missing quotes in JSON strings
Storing arrays as strings
Invalid JSON syntax
Master "JSON and JSONB" in PostgreSQL
9 interactive learning modes - each teaches the same concept differently
