[Solved] What is the correct way to insert JSON data into a PostgreSQL table with a json column named data? — Ans: INSERT INTO table_name (data) VALUES ('{"name": "John", "age": 30}'); | PostgreSQL

PostgreSQL - JSON and JSONB

What is the correct way to insert JSON data into a PostgreSQL table with a json column named data?

AINSERT INTO table_name (data) VALUES (JSON('name: John, age: 30'));

BINSERT INTO table_name (data) VALUES ({name: 'John', age: 30});

CINSERT INTO table_name (data) VALUES ("{'name': 'John', 'age': 30}");

DINSERT INTO table_name (data) VALUES ('{"name": "John", "age": 30}');

Step-by-Step Solution

Solution:

Step 1: Use single quotes for JSON string in SQL
In PostgreSQL, JSON data must be enclosed in single quotes as a string literal.
Step 2: Use valid JSON format inside the string
The JSON must have double quotes around keys and string values, like {"name": "John", "age": 30}.
Final Answer:
INSERT INTO table_name (data) VALUES ('{"name": "John", "age": 30}'); -> Option D
Quick Check:
JSON string with single quotes and double quotes inside = D [OK]

Quick Trick: Always use single quotes around JSON string in SQL [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the correct way to insert JSON data into a PostgreSQL table with a json column named data?