HOW TO INSERT JSON (PostgreSQL )

Question

I want to insert JSON with the value of the array from postgrsql to value into JSON-type columns. What should I do?

CREATE TABLE jsonlist (col JSON);

INSERT INTO jsonlist(col)
VALUES ('{"usrGrp":"{1,2,3}"}');

In JSON arrays are surrounded by square brackets [1,2,3]

user330315
– user330315

2023-02-07 06:36:02 +00:00
Commented Feb 7, 2023 at 6:36 — user330315
– user330315, Commented Feb 7, 2023 at 6:36

buddemat · Accepted Answer · 2023-02-09 11:25:49Z

1

I got it:

'{"action":"del","usrId": ["yjshin","test111"],"usrGrpId": [1,2]}'

You can use brackets to tie up what you want to make a list. Note that in the array, the string had to enclose each element in double quotes, and the entire JSON had to be enclosed in single quotes.

edited Feb 9, 2023 at 11:25

buddemat

5,33016 gold badges37 silver badges61 bronze badges

answered Feb 7, 2023 at 6:36

Kim Min-Uk

111 bronze badge

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

1 Comment

Álvaro González Over a year ago

This doesn't have anything to do with the question. To insert JSON you just need to pack it into a string literal (or pass it as parameter in a prepared statement). It behaves like regular strings, JSON doesn't need any special treatment. You're seemingly asking how to encode arrays in JSON, which is a different thing.

Collectives™ on Stack Overflow

HOW TO INSERT JSON (PostgreSQL )

1 Answer 1

1 Comment

Your Answer

Collectives™ on Stack Overflow

HOW TO INSERT JSON (PostgreSQL )

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related