SQL · JSON functions

json ->> operator

Reads a JSON value as text. PostgreSQL and SQLite.

sqlRunnable example sql course

Syntax

json ->> '$.key'

Example

Open in the lab

SELECT '{"a":1}' ->> '$.a' AS value;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.