*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
SELECT
users.id AS user_id,
jsonb_extract_path_text (users.jsonb, 'status') AS patron_status,
FROM folio_users.users
The following expression will also get the value for "status":
SELECT
users.id AS user_id,
users.jsonb #>> '{status}" AS patron_status,
FROM folio_users.users
Extracting "Second Level" Data Fields
...