Insert json with strings with quotes within them to Postgres

Question

I have some JSON I'm trying to insert into a Postgres database but I can't manage to properly escape the quotes, here's my code

insert into Product_Templates (product) values( '{
"template_id": "OSBSheet",
"name":'Exterior Wall Using 2\"x4\"x96\" Studs, Double Top Plate'

}

I get the error: invalid command \"x96

How do I work around this?

klin · Accepted Answer · 2017-11-28 00:08:23Z

1

See the JSON syntax. The keys and string values in JSON are enclosed in double quotes. The quotation marks in strings must be preceded by a "\" character:

select
'{
    "template_id": "OSBSheet",
    "name": "Exterior Wall Using 2\"x4\"x96\" Studs, Double Top Plate"
}'::jsonb

                                              jsonb                                              
-------------------------------------------------------------------------------------------------
 {"name": "Exterior Wall Using 2\"x4\"x96\" Studs, Double Top Plate", "template_id": "OSBSheet"}
(1 row)

answered Nov 28, 2017 at 0:08

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RobinReborn Over a year ago

I've changed that, I still get the same error, invalid command \"x96

RobinReborn Over a year ago

Thanks, the issue was with other inserts above that were improperly formatted

Collectives™ on Stack Overflow

Insert json with strings with quotes within them to Postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related