PostgreSQL insert query using jsonb data type

Question

I'm trying to use JSONB data type in PostgreSQL for my product table, like the following example:

Then, when I execute the below INSERT query for this table, the query is not executed !

INSERT INTO PRODUCT 
VALUES 
(7, 'iPhone8', 'Grey', 700.00, 34, '{"storage": 256, "RAM": 16, "resolution": 1700X456 }')

Please do not post code as images. See here for more details why: meta.stackoverflow.com/questions/285551 — a_horse_with_no_name

nachospiu nachospiu · Accepted Answer · 2021-03-22T15:42:05

You forgot double quotes in value "1700X456" (it is a string, not a number).

INSERT INTO PRODUCT 
VALUES 
(7, 'iPhone8', 'Grey', 700.00, 34, '{"storage": 256, "RAM": 16, "resolution": "1700X456" }')