Postgres: How to convert a json string to text?

by

In 9.4.4 using the #>> operator works for me:

select to_json('test'::text) #>> '{}';

To use with a table column:

select jsoncol #>> '{}' from mytable;

More Related Contents:

  1. How do I modify fields inside the new PostgreSQL JSON datatype?
  2. Flatten aggregated key/value pairs from a JSONB field?
  3. Explanation of JSONB introduced by PostgreSQL
  4. How to query a json column for empty objects?
  5. PostgreSQL return result set as JSON array?
  6. How to create index on JSON field in Postgres?
  7. How to convert postgres json to integer
  8. Postgres JSON data type Rails query
  9. Check if a Postgres JSON array contains a string
  10. Merging JSONB values in PostgreSQL?
  11. Collect Recursive JSON Keys In Postgres
  12. Size limit of JSON data type in PostgreSQL
  13. In postgresql, how can I return a boolean value instead of string on a jsonb key?
  14. Go JSON Naming strategy about extends
  15. How do I initialize a TypeScript Object with a JSON-Object?
  16. Posting a File and Associated Data to a RESTful WebService preferably as JSON
  17. How to escape double quotes in JSON
  18. How to convert arbitrary simple JSON to CSV using jq?
  19. With JSONDecoder in Swift 4, can missing keys use a default value instead of having to be optional properties?
  20. JSON Specification and usage of BOM/charset-encoding
  21. Can’t send a post request when the ‘Content-Type’ is set to ‘application/json’
  22. In Excel VBA on Windows, for parsed JSON variables what is this JScriptTypeInfo anyway?
  23. How to format a JSON string as a table using jq?
  24. How to create dynamic routes with react-router-dom?
  25. OpenAPI query string parameter with list of objects
  26. OpenAPI path/query parameters nested structure serialization
  27. Decoding Error — Expected to decode Dictionary but found an array instead
  28. Can anyone explain how to get all the mismatch between two responses in karate?
  29. Can a JSON value contain a multiline string
  30. Is there an API call for changing user password on keycloak?

Leave a Comment