Save jsonb in postgres database

Question

I have a table in Postgres with a jsonb column. I'm using Entity Framework to upsert data on this table, but I'm always getting the error

Input string was not in a correct format

because of the jsonb column.

This is an example of a query I generate:

INSERT INTO example_table (id, name, details) 
VALUES (1, 'john','{\r\n  \"age\": \"17\"\r\n}') 
ON CONFLICT (name) DO NOTHING

This is the command I'm trying to execute:

_context.ExecuteSqlRaw("INSERT INTO example_table (id, name, details) VALUES (1, 'john','{\r\n  \"age\": \"17\"\r\n}') ON CONFLICT (name) DO NOTHING");

If I remove the json the query is executed perfectly.

What am I doing wrong?

Ramin Faracov · Accepted Answer · 2022-12-02 18:03:26Z

0

Json and Jsonb doesn't support \n, \r symbols. Use this:

INSERT INTO example_table (id, name, details) 
VALUES 
(1, 'john','{"age":"17"}') 
ON CONFLICT (name) DO NOTHING

answered Dec 2, 2022 at 18:03

Ramin Faracov

3,3331 gold badge6 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Save jsonb in postgres database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related