[Solved] Which of the following is the correct syntax to create a table with a JSON column named data? — Ans: CREATE TABLE mytable (id INT, data JSON); | PostgreSQL

PostgreSQL - JSON and JSONB

Which of the following is the correct syntax to create a table with a JSON column named data?

ACREATE TABLE mytable (id INT, data JSONB STRING);

BCREATE TABLE mytable (id INT, data JSON);

CCREATE TABLE mytable (id INT, data TEXT JSON);

DCREATE TABLE mytable (id INT, data STRING);

Step-by-Step Solution

Solution:

Step 1: Recall JSON column syntax
In PostgreSQL, JSON columns are declared with type JSON or JSONB directly.
Step 2: Check each option
CREATE TABLE mytable (id INT, data JSON); uses correct syntax. Options A, B, and C use invalid or mixed types.
Final Answer:
CREATE TABLE mytable (id INT, data JSON); -> Option B
Quick Check:
JSON column syntax = CREATE TABLE mytable (id INT, data JSON); [OK]

Quick Trick: Use JSON or JSONB as column type directly [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to create a table with a JSON column named data?