[Solved] You try to create a table with a JSON column using:CREATE TABLE users (id INT, profile JSONB DEFAULT {});But get a syntax error. What is the problem? | PostgreSQL

PostgreSQL - JSON and JSONB

You try to create a table with a JSON column using:
CREATE TABLE users (id INT, profile JSONB DEFAULT {});
But get a syntax error. What is the problem?

AMissing quotes around the default JSON value

BJSONB columns cannot have default values

CEmpty braces {} are not valid default for JSONB

DINT type cannot be used with JSONB columns

Step-by-Step Solution

Solution:

Step 1: Check default value syntax for JSONB
Default JSON values must be valid JSON strings, so '{}' must be in single quotes.
Step 2: Identify the error cause
Using {} without quotes causes syntax error. Correct is DEFAULT '{}'.
Final Answer:
Missing quotes around the default JSON value -> Option A
Quick Check:
Default JSON must be quoted [OK]

Quick Trick: Always quote JSON default values as strings [OK]

Common Mistakes:

Using unquoted braces {} as default
Assuming JSONB cannot have defaults
Confusing data types in table definition

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

You try to create a table with a JSON column using:

Step 1: Check default value syntax for JSONB

Step 2: Identify the error cause

Final Answer:

Quick Check:

Want More Practice?