How to create index on JSON field in Postgres?

by

Found:

CREATE TABLE publishers(id INT, info JSON); 
CREATE INDEX ON publishers((info->>'name'));

As stated in the comments, the subtle difference here is ->> instead of ->. The former one returns the value as text, the latter as a JSON object.

More Related Contents:

  1. How do I modify fields inside the new PostgreSQL JSON datatype?
  2. Check if a Postgres JSON array contains a string
  3. How do I query using fields inside the new PostgreSQL JSON datatype?
  4. Index for finding an element in a JSON array
  5. Flatten aggregated key/value pairs from a JSONB field?
  6. Explanation of JSONB introduced by PostgreSQL
  7. Postgres: How to convert a json string to text?
  8. How to query a json column for empty objects?
  9. PostgreSQL return result set as JSON array?
  10. Query for element of array in JSON column
  11. How to convert postgres json to integer
  12. Postgres JSON data type Rails query
  13. PostgreSQL Index on JSON
  14. Merging JSONB values in PostgreSQL?
  15. Collect Recursive JSON Keys In Postgres
  16. Size limit of JSON data type in PostgreSQL
  17. In postgresql, how can I return a boolean value instead of string on a jsonb key?
  18. Do the JSON keys have to be surrounded by quotes?
  19. Setting Access-Control-Allow-Origin in ASP.Net MVC – simplest possible method
  20. Unmarshal JSON with some known, and some unknown field names
  21. Django JSONField inside ArrayField
  22. List columns with indexes in PostgreSQL
  23. Split given string and prepare case statement
  24. Best way to save data in Unity game [closed]
  25. PowerShell 2.0 ConvertFrom-Json and ConvertTo-Json implementation
  26. Json Java serialization that works with GWT [closed]
  27. Coldfusion 10 returnformat=”JSON” adding characters
  28. Iterate a Json Object with ngFor
  29. respond to http request with json object in portlet
  30. Is there an API call for changing user password on keycloak?

Leave a Comment