How to insert json into postgre? #816
-
|
my json {
"username": "admin",
"topic": "asdf",
"pub_props" : {"age":"22","sex",0}
}In the body, How to solve it? |
Beta Was this translation helpful? Give feedback.
Replies: 6 comments 1 reply
-
|
@wuzhen1228 Could you share your table structure? |
Beta Was this translation helpful? Give feedback.
-
|
@wuzhen1228
from: |
Beta Was this translation helpful? Give feedback.
-
yes，but it still prompts an error |
Beta Was this translation helpful? Give feedback.
-
The type of the field is jsonb |
Beta Was this translation helpful? Give feedback.
-
The type of the field is jsonb |
Beta Was this translation helpful? Give feedback.
-
|
@avelino , not supported jsonb filed insert ? |
Beta Was this translation helpful? Give feedback.
-
|
prest has jsonb support https://docs.prestd.com/prestd/docs/api-reference/advanced-queries/ I use jsonb in several projects |
Beta Was this translation helpful? Give feedback.
@wuzhen1228
in your json has a typo, was it a typo
,or are you using it this way in the request?"pub_props" : {"age":"22","sex",0}from:
"sex",0to:
"sex":0