Add element to JSON object in Postgres

by

If you upgrade to PG9.5.1, then you can use sql operator || to merge jsonb, example

select '{"a":1}'::jsonb || '{"a":2, "b":2}'::jsonb

will return {"a": 2, "b": 2}

If you can’t upgrade to pg9.5.1, IMHO, doing the job in your code will be a better choice. You can parse old jsonb string as a map, and then update the map, then convert to string and update db-record.

And if we want to update (add) a JSONB field:

UPDATE <table>
SET <field-name> = <field-name> || '{"a": 1}'::jsonb
WHERE id = <some id>

Documentation detailing all JSON operations in Postgres 9.5

Related Contents:

  1. Are multi-line strings allowed in JSON?
  2. Explanation of JSONB introduced by PostgreSQL
  3. Select objects based on value of variable in object using jq
  4. How do I modify fields inside the new PostgreSQL JSON datatype?
  5. PostgreSQL return result set as JSON array?
  6. Check if a Postgres JSON array contains a string
  7. How to create index on JSON field in Postgres?
  8. how to parse a JSON String with jq (or other alternatives)?
  9. PostgreSQL Nested JSON Querying
  10. Postgres: How to convert a json string to text?
  11. How can I get all keys from a JSON column in Postgres?
  12. Size limit of JSON data type in PostgreSQL
  13. How to parse JSON in postgresql
  14. How do I check if a json key exists in Postgres?
  15. Difference between JSON and JSONB in Postgres [duplicate]
  16. Check if field exists in json type column PostgreSQL
  17. How to convert postgres json to integer
  18. Postgres JSON data type Rails query
  19. how to convert json string to json object in dart flutter?
  20. Remove double quotes from the return of a function in PostgreSQL
  21. PostgreSQL rename attribute in jsonb field
  22. How do I search for a specific string in a JSON Postgres data type column?
  23. Can JSON numbers be quoted?
  24. Couldnt identify equality operator of type json[] when using UNION
  25. Handling Unicode sequences in postgresql
  26. How-to loop over JSON Arrays in postgresql 9.3
  27. Postgresql query for objects in nested JSONB field
  28. What data type to choose json or jsonb or text
  29. Replacing escape characters from JSON
  30. uncaught syntaxerror unexpected token U JSON
  31. Replace part of a string with another string
  32. How do I query using fields inside the new PostgreSQL JSON datatype?
  33. Tool to generate JSON schema from JSON data [closed]
  34. In GraphQL what’s the meaning of “edges” and “node”?
  35. Curl GET request with json parameter
  36. How to format a JSON string as a table using jq?
  37. How to send a POST request with BODY in swift
  38. Convert Pandas DataFrame to JSON format
  39. Javascript: Remove last character if a colon
  40. Can MySQL replace multiple characters?
  41. Using codable with value that is sometimes an Int and other times a String
  42. Converting object to an encodable object failed
  43. What does `app.use(bodyParser.json())` do?
  44. Replace all quotes in a string with escaped quotes?
  45. How to use default serialization in a custom JsonConverter
  46. JSON golang boolean omitempty
  47. How to convert a json response into yaml in bash
  48. what is the purpose of using square brackets in json? [duplicate]
  49. AngularJS – $http.post send data as json
  50. json schema date-time does not check correctly

Leave a Comment